Hi. I will like to get the % of the subcategory. The red column. What is the measure formula to use?
1 ACCEPTED SOLUTION
pls try this
Measure = sumx(FILTER('Table','Table'[Category]="CPF"),'Table'[Amount])/sumx(FILTER('Table','Table'[Category]="Applicable for CPF"),'Table'[Amount])
pls try this
Measure = sumx(FILTER('Table','Table'[Category]="CPF"),'Table'[Amount])/sumx(FILTER('Table','Table'[Category]="Applicable for CPF"),'Table'[Amount])
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
