Matrix table Row Total how to change

[Varan_15]

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.

[Varan_15]

Thanks @visheshjain ,

It's working fine as expected.

[visheshjain · Accepted 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