Forum Discussion
Solved
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...
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.
Hi my only measure in this
Tickets = COUNTROWS(WHD_Tickets)
I would like to have the number of tickets and the % to the grand total.
many thanks!
drag that measure to both the value slot and the tooltip slot. Select the drop down arrow on the side of the measure in the tool tip slot and click show value as>% grand total.