Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
Hi experts!
I am just playing aroung with a simple % stacked bar chart and somehow the measure remains to stay in a format for thousand.
Instead of 100% I get 0K%.
I haven't applied any format settings. It is a sample count measure.
What is the issue here?
Thanks
Hi @joshua1990,
A common pattern for a percentage calculation might look something like:
Percentage Measure =
DIVIDE(
COUNT(YourTable[SomeColumn]),
CALCULATE(COUNT(YourTable[SomeColumn]), ALL(YourTable)),
0
)
Hope this helps.
User | Count |
---|---|
91 | |
75 | |
71 | |
59 | |
55 |
User | Count |
---|---|
41 | |
39 | |
34 | |
32 | |
30 |