Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 ?
Solved! Go to Solution.
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.
@Rahulmg2002
Create a measure instead:
Example:
PercentageOfGrandTotal =
DIVIDE(
SUM('YourTable'[YourField]),
CALCULATE(SUM('YourTable'[YourField]), ALL('YourTable'))
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!