Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |