Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I'm trying to calculate the percentage of the column and sub culumn subtotal for each sub-category in Matrix visual :
I duplicated the table and tried to calculate the value as the percent of the column total but the calculation done by the column subtotal :
The actual calculation is the red field divided by the blue field, the desired calculation should be the red divided by the green field - in this case - 48.51%.
The calculation should be applied for all the fields in Table 2, any ideas?
Thanks
Solved! Go to Solution.
@Naorsh123
You can create a measure as follows:
Percentage of Row =
VAR __SalesAmount = [Sales Amount]
VAR __RowSubTotal = CALCULATE( [Sales Amount] , REMOVEFILTERS( 'Product'[Subcategory] ))
VAR __GrandSubTotal = CALCULATE( [Sales Amount] , REMOVEFILTERS( 'Product'[Category] , 'Product'[Subcategory] ))
VAR __ResultSubTotal = DIVIDE( __SalesAmount, __RowSubTotal)
VAR __ResultGrandTotal = DIVIDE( __SalesAmount, __GrandSubTotal)
RETURN
IF( ISINSCOPE( 'Product'[Subcategory] ) , __ResultSubTotal , __ResultGrandTotal)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Naorsh123
You can create a measure as follows:
Percentage of Row =
VAR __SalesAmount = [Sales Amount]
VAR __RowSubTotal = CALCULATE( [Sales Amount] , REMOVEFILTERS( 'Product'[Subcategory] ))
VAR __GrandSubTotal = CALCULATE( [Sales Amount] , REMOVEFILTERS( 'Product'[Category] , 'Product'[Subcategory] ))
VAR __ResultSubTotal = DIVIDE( __SalesAmount, __RowSubTotal)
VAR __ResultGrandTotal = DIVIDE( __SalesAmount, __GrandSubTotal)
RETURN
IF( ISINSCOPE( 'Product'[Subcategory] ) , __ResultSubTotal , __ResultGrandTotal)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |