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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
