Forum Discussion

Varan_15's avatar
Varan_15
Icon for Helper III rankHelper III
3 years ago
Solved

Matrix table Row Total how to change

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.
Need Help
  • visheshjain's avatar
    visheshjain
    3 years ago

    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

     

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

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