Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When I want to make cumulative total for my table that you can see below, my formula returns wrong cumulative total for each distributor row. Can you help me to solve this issue ? (What I want is to see %18,7 1.row - % 32,1 2.row - 39,1 3.row etc.)
My cumulative total formula :
Solved! Go to Solution.
@Anonymous
Try:
RANKX % Sum ratio = RANKX(ALL(table[DistName]); [Sum Ratio]; ;DESC)
Followed by:
Cumulative % Sum Ratio = SUMX(TOPN([RANKX % Sum ratio]; ALL(table[DistName]); [Sum Ratio]); [Sum Ratio])
And to get rid of the total:
Cumulative without total in matrix = IF(ISINSCOPE(table[DistName]); [Cumulative % Sum Ratio]; BLANK())
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
Try:
RANKX % Sum ratio = RANKX(ALL(table[DistName]); [Sum Ratio]; ;DESC)
Followed by:
Cumulative % Sum Ratio = SUMX(TOPN([RANKX % Sum ratio]; ALL(table[DistName]); [Sum Ratio]); [Sum Ratio])
And to get rid of the total:
Cumulative without total in matrix = IF(ISINSCOPE(table[DistName]); [Cumulative % Sum Ratio]; BLANK())
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous ,
Please give a try to below DAX Measure:
Cumulative Sum=
CALCULATE ( SUM ( 'Table'[Sum Ratio] ), FILTER ( ALL ( 'Table' ), 'Table'[DateColumn] <= MAX ( 'Table'[DateColumn] ) ) )
Please give Kudos this effort and mark it as a solution if it helps!!!
Dear @Tahreem24 ,
Unfortunately formula you type does not work. You can see the result below :
Apart from that, why do I need to use date formula ?
Best Regards.
@Anonymous ,
Date field is used to check the prevoius date so accordingly it will add up your Sum Ratio value.
But I do not want to see cumulative total based on date, I just want to see it based on from large to small in distributor level.
You are using calendar date, I think you should use DistName
If possible please share a sample pbix file after removing sensitive information.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |