Forum Discussion
Solved
PowerBI aggregation function. percentage by grand total
I have built my report i powerbi 2.124.2028.0 . i have done a table visuals and converted counts to percentage by grand total . Now i am trying to do same but my aggregation drop down is greyed out. ...
thank you Fowmy for your reply. i was stupid, i got the answer of my question. it was just right click on the field and show value as Percentage of grand total.
Fowmy
Super User
Super UserRahulmg2002
Create a measure instead:
Example:
PercentageOfGrandTotal =
DIVIDE(
SUM('YourTable'[YourField]),
CALCULATE(SUM('YourTable'[YourField]), ALL('YourTable'))
)
thank you Fowmy for your reply. i was stupid, i got the answer of my question. it was just right click on the field and show value as Percentage of grand total.