Forum Discussion

hanhks's avatar
hanhks
Frequent Visitor
8 years ago
Solved

Matrix Condition Format Base On Diagonal

I have a matrix summary check same item from 2 people. Each person has result difference with other. I make matrix compare results from them. I want to make matrix like below. Please help me, It's po...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi hanhks

    Look at my test

    in query editor, add two conditional columns

    Then create a measure

    Measure = IF(MAX([Custom1])>MAX([Custom2]),1,IF(MAX([Custom1])=MAX([Custom2]),0,-1))

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi hanhks

Look at my test

in query editor, add two conditional columns

Then create a measure

Measure = IF(MAX([Custom1])>MAX([Custom2]),1,IF(MAX([Custom1])=MAX([Custom2]),0,-1))

 

Best Regards

Maggie

  • hanhks's avatar
    hanhks
    Frequent Visitor
    8 years ago

    v-juanli-msft

    I tested by your guide and it's OK. Very nice. Thank you.