Forum Discussion

Varan_15's avatar
Varan_15
Helper 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

     

2 Replies

  • visheshjain's avatar
    visheshjain
    Impactful 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