topic Re: Total sum for equal values - measure in Power BI in DAX Commands and Tips

Total sum for equal values - measure in Power BI

mniepytalska_ — Sun, 15 Sep 2024 12:10:34 GMT

Hey,

I would like to kindly ask for help on writing a measure that will add line by line a variable called “%”

I have a table in Power BI:

And I need a table with the measure “Total sum” as below:

My problem is to calculate the cumulative sum for values that are the same, maybe it is possible to add the ranking per row, where for 17% will be 1 and 2?
Thank you in advance for your help!

Re: Total sum for equal values - measure in Power BI

Jihwan_Kim — Sun, 15 Sep 2024 13:21:42 GMT

Hi,

Please check the below picture and the attached pbix file.

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

One of ways to achieve this is using WINDOW dax function and try order the sequence by percent value descending and by type number ascending at the same time.

WINDOW function (DAX) - DAX | Microsoft Learn

expected result measure: = CALCULATE ( [percent %], WINDOW ( 1, ABS, 0, REL, ALL ( data[type] ), ORDERBY ( [percent %], DESC, data[type], ASC ) ) )

Re: Total sum for equal values - measure in Power BI

mniepytalska_ — Mon, 16 Sep 2024 15:29:17 GMT

Jihwan_Kim Thank you so much! managed to do on my report, on my model :)))