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.
Hi All,
I need help in creating a measure to calculate cumulative total. I was able to do it in my other report and I'm trying to replicte it. Not sure what is wrong but the cumulative total is showing the total for all instead.
Here's the dataset i used for a table called Pareto (the dataset is exported from a calculated table using ADDCOLUMNS and SUMMARIZE)
https://www.dropbox.com/s/ze7ac9001jsm1h1/Pareto.xlsx?dl=0
I created a calculated column for the rank
Questions Ranking = RANKX ( Pareto, Pareto[Occurence] )
And this measure for cumulative ranking
Cumulative Callout Occurence = CALCULATE ( sum(Pareto[Occurence]), FILTER ( ALLSELECTED ( Pareto ), Pareto[Questions Ranking] <= MAX ( Pareto[Questions Ranking] ) ) )
It supposed to show cumulative total based on ranking but the measure is showing overall total.
The first table in the image below is by Questions, the second one is by rank
Thanks in advance for the help!
Proud to be a Super User!
Solved! Go to Solution.
In this scenario, you want to analyze on Question Level, when you calculate "cumulative total based on ranking", this "ranking" should be group on Question Level. So your ranking column should be like:
Questions Ranking = RANKX ( ALL(Pareto[Questions]), CALCULATE(SUM(Pareto[Occurence]),ALLEXCEPT(Pareto,Pareto[Questions])),,DESC,Dense)
Then you cumulative total measure should work properly.
Regards,
In this scenario, you want to analyze on Question Level, when you calculate "cumulative total based on ranking", this "ranking" should be group on Question Level. So your ranking column should be like:
Questions Ranking = RANKX ( ALL(Pareto[Questions]), CALCULATE(SUM(Pareto[Occurence]),ALLEXCEPT(Pareto,Pareto[Questions])),,DESC,Dense)
Then you cumulative total measure should work properly.
Regards,
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |