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,
am having a small issue with a new measure i want to make and this is the case:
the report contains casenumbers (like 123456) which i transformed via count to a nr and next to the case nr i have a type (cancellation/delivery). At the end i have 2 columns:
count of caseNumbers Type
100 delivery
50 cancellation
Now i want to have a third column (new measure) with the percentage of the grand total (=150). Example for type delivery the percentage is 67%.
any ideas how to do this especially as the case numbers needs to be counted....
thanks in advance
M
Solved! Go to Solution.
Hi @emveha,
Assume data likes below:
You can create a measure below:
Percentage = var t=SUMMARIZE(ALL(Table1),Table1[Type],"count",DISTINCTCOUNT(Table1[CaseNumber]))
return
DIVIDE(CALCULATE(DISTINCTCOUNT(Table1[CaseNumber]),ALLEXCEPT(Table1,'Table1'[Type])),SUMX(t,[count]))
Best Regards,
Qiuyun Yu
Hi @emveha,
Assume data likes below:
You can create a measure below:
Percentage = var t=SUMMARIZE(ALL(Table1),Table1[Type],"count",DISTINCTCOUNT(Table1[CaseNumber]))
return
DIVIDE(CALCULATE(DISTINCTCOUNT(Table1[CaseNumber]),ALLEXCEPT(Table1,'Table1'[Type])),SUMX(t,[count]))
Best Regards,
Qiuyun Yu
THANK YOU - I was looking everywhere for a solution. This is great, Qiuyun!
hi Qiuyun Yu,
thanks for swift response and offering this solution, it works!!
M
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |