Forum Discussion

Rahulmg2002's avatar
Rahulmg2002
Frequent Visitor
2 years ago
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. any suggestions ?

General Comment
Need Help
  • Rahulmg2002's avatar
    Rahulmg2002
    2 years ago

    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. 

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    Rahulmg2002 
    Create a measure instead:

    Example:

    PercentageOfGrandTotal = 
DIVIDE(
  SUM('YourTable'[YourField]), 
  CALCULATE(SUM('YourTable'[YourField]), ALL('YourTable'))
)
    • Rahulmg2002's avatar
      Rahulmg2002
      Frequent Visitor
      2 years ago

      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.