Forum Discussion
imy
7 years agoHelper I
Percentages
Hello, I wonder if you can help me: I am trying to create a bar chart with percentages. The only value in my data is a New Measure I created that counts the rows on the table. This works well for e...
- 7 years ago
Instead of relying on quick measures, build the measure you want. You have:
Tickets = COUNTROWS(WHD_Tickets)
Build one to show % Grand Total:
%Grand Total =
VAR AllWhdTickets = CALCULATE([Tickets], ALL(Table[Status]))
Return
DIVIDE([Tickets], AllWhdTickets)
Please keep in mind that I do not know what your table is named or the column for your descriptions, you will need to put the correct data into the variable.