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!
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
