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.
Dear calebmfoster
Thank you for your answer but I do not have a % to grand total measure, how do I do this?
Remember the other reply I made and told you to drag your measure into values and hit the drop down menu? Do that but drag it to tool tip instead