Hi
So I am trying to apply conditional formatting to a matrix (based on a bunch of avg values) which I know how to do but I need help with the dax command to use.
Basically what the title says, very easy to explain I basically want a cell highlighted if the max value is .3 higher than the second highest value. I'll provide a sample of what I am looking for.
| person1 | person2 | person3 | person4 | person5 |
| 4.2 | 3.9 | 3.8 | 3.4 | 3.6 |
| 3.1 | 4.1 | 3.6 | 3.7 | 3.6 |
| 4 | 3.9 | 3.8 | 3.6 | 3.2 |
so the ones highlighted in orange are .3 higher than the 2nd highest value in its row and in the 3rd row nothing is highlighted because it isn't .3 higher.
