The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all
I have the following table result
As seen the first row doesn't show the cumulative percentage, and the 4th row in the cumulative column is not summing correctly.
The DAX I have is:
Pareto UC Cumulative =
VAR TotalUC = CALCULATE([Volume],ALLSELECTED('Ship From'))
VAR CurrentUC = [Volume]
VAR SummarizedTable =
SUMMARIZE(
ALLSELECTED('Ship From'),
'Ship From'[Bottler Owner],
"Volume", [Volume])
VAR CumSum =
SUMX(
FILTER(SummarizedTable,[Volume]>=CurrentUC),
[Volume]
)
Return
DIVIDE(CumSum,TotalUC)
Any idea what could be wrong?
Thanks.
Here is the table:
Bottler Owner | Volume | Pareto UC Cumulative | Pareto UC |
1 | 480,600,034.00 | 37.01% | |
2 | 378,390,784.00 | 66.14% | 29.14% |
3 | 216,308,340.00 | 82.80% | 16.66% |
4 | 101,168,972.00 | 82.80% | 7.79% |
5 | 44,268,330.00 | 94.00% | 3.41% |
6 | 29,624,323.00 | 96.28% | 2.28% |
7 | 29,249,209.00 | 98.53% | 2.25% |
8 | 17,656,202.00 | 99.89% | 1.36% |
9 | 1,429,489.00 | 100.00% | 0.11% |
10 | 100.00% |
Solved! Go to Solution.
Hi,
I tried to create a sample data for myself and then create measures on it, the result is below :
-----------------------------------
Hi,
I tried to create a sample data for myself and then create measures on it, the result is below :
-----------------------------------
Hi,
Share the link from where i can download your PBI file.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
107 | |
75 | |
61 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
88 |