Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |