How to calculate difference score in matrix visual

[BrittH]

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. However, NL 13 and UT are not measures. They are rows in the Excel column 'Instellingen' in the Excel table 'UT_NL_totaal'. How can I add a new score 'difference NL 13 vs UT' and show that in the matrix as an extra column? 

[Uzi2019 · Accepted solution]

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!

[BrittH]

Hello @Uzi2019 ,

Thank you for your help. What do I need to fill in for 'amount'? 

Best,

Britt 

[Uzi2019]

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]

@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]

Hi @BrittH 

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