Sum the measure according to Range given in range table

DAX DAX Calculations
1

Hi All,

I had my solution for benefits investigation at this link. I am trying further calculations to aggregate the values from measure by ranges.

I know its really simple, something related to SUM but I cannot figure it out. Below is the screenshot for calculation that I achieved in excel by using pivot table
Capture
This screen shot is just an example that i was experimenting . Original ranges will be 1-20, 21-30, 31-40 and 50+

This is the link for PBIX file Test(6)

2

Hi @PranjaliK ,

I created a calculated column in your Table1 to create the groups you need.
Then it’s a SUMX function as you said.

See my solution below :
test (6).pbix (295.0 KB)

I hope it will help you.

Best regards,
Joaly

3

I always think about the hardest way possible and get lost while finding the solution :confused:
Thank You @JBocher this works just as I need.