Aggregrating the rows issue

Hi: Need help with the below Power BI dashboard issue


Issue: In the dashboard I am displaying data in tabular form. But it’s not aggregating the data (key figures) based on the key (dimensions) value. Here is the example I have the below 6 rows in my output

Column1---Column2---Column3---Column4
ABC---INDIA---RED---4
ABC---INDIA---GREEN---6
ABC---INDIA---GREEN---2
XYZ---INDIA---RED---5
XYZ---INDIA---RED---8
XYZ---INDIA---RED---2

The desired output to show in the dashboard is like below

ABC---INDIA---RED---4
ABC---INDIA---GREEN---8
XYZ---INDIA---RED---15

Basically numeric values need to be aggregated to the Char Key values. It’s not working for me. Am I missing any setting??? If you can help me technically to fix this, I am willing to pay for your time. Please contact me at aveluru12@gmail.com