Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have 2 category A and B if i show in matrix table the ROW TOTAL should show like below
Row total = Category A- Category B
please help how to achive this in matrix table.
Solved! Go to Solution.
Hi @Varan_15,
This is how I made the sample data and depending on your model the measure might need to be tweaked.
ProductCategoryAmount
Fruits |
A |
200 |
Fruits |
B |
50 |
Veg |
A |
600 |
Veg |
B |
40 |
Here are the 2 measures that I created:
Total = SUM('Table'[Amount])
Net Total = IF( NOT(ISINSCOPE('Table'[Category])), CALCULATE([Total], FILTER('Table', 'Table'[Category] = "A")) - CALCULATE([Total], FILTER('Table', 'Table'[Category] = "B")), [Total] )
This is the result obtained:
Hope this answers your question and if it does please kudo it and/or mark it as the solution so that others can reach it faster.
Thank you,
Vishesh Jain
Proud to be a Super User!
Hi @Varan_15,
This is how I made the sample data and depending on your model the measure might need to be tweaked.
ProductCategoryAmount
Fruits |
A |
200 |
Fruits |
B |
50 |
Veg |
A |
600 |
Veg |
B |
40 |
Here are the 2 measures that I created:
Total = SUM('Table'[Amount])
Net Total = IF( NOT(ISINSCOPE('Table'[Category])), CALCULATE([Total], FILTER('Table', 'Table'[Category] = "A")) - CALCULATE([Total], FILTER('Table', 'Table'[Category] = "B")), [Total] )
This is the result obtained:
Hope this answers your question and if it does please kudo it and/or mark it as the solution so that others can reach it faster.
Thank you,
Vishesh Jain
Proud to be a Super User!