Forum Discussion

BrittH's avatar
BrittH
Regular Visitor
2 years ago
Solved

How to calculate difference score in matrix visual

Hello,   I was wondering whether anyone can help me.   In the screenshot below you see a matrix. I want to have another column in that matrix showing the difference score between NL 13 and UT. Ho...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi BrittH 
    Create below meausre like this

    Final =
     var NL= calculate( sum(amount), Intelligen= "NL 13")
    var UT= calculate (Sum(amount), Intelligen= "UT")
    var Difference = [NL]- [UT]

    Return Difference

     

    I hope it may resolves your issue!

     

     

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

Hi BrittH 

 

I think you are taking Mean  in value section of a Matrix.

So change the formula according to you numeric value taken in your table.

 

 

BrittH's avatar
BrittH
Regular Visitor
2 years ago

Uzi2019 Thank you. I tried that. I have a measure now. I am not sure it is correct. Anyhow, I cannot add it to the columns in the visual. When I drag it to Columns under Visualizations, it does not stay there.

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi BrittH 

    Try to take all value in table visuals not in matrix for testing purpose.