Forum Discussion

pyramid1's avatar
pyramid1
Frequent Visitor
3 years ago
Solved

Matrix - Total between two columns with two row header.

Hello expert, I need some help with Matrix.   Here is my sample data: I am expecting below output: While playing with matrix , I couldn't get to expected output. So anyhelp would be a...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

     

pyramid1's avatar
pyramid1
Frequent Visitor
3 years ago

Jihwan_Kim  what would be the best way to find difference between two measure (is Diff Measure from Salary and Diff Measure from Tax). 

 

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

    Salary diff - Tax diff measure: = 
CALCULATE ( [Diff measure:], Category[Category] = "Salary" )
    - CALCULATE ( [Diff measure:], Category[Category] = "Tax" )

     

    • pyramid1's avatar
      pyramid1
      Frequent Visitor
      3 years ago

      Awesome Thanks. IS there a way to add this "Salary Diff - Tax diff Measure" as a separate column (With new category "Difference") in report after "Tax Diff Measure"?