https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Highlight-cell-if-value-is-3-higher-than-next-highest-value/m-p/3275332#M121489 <P>Hi</P><P>&nbsp;</P><P>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.&nbsp;</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>person1</TD><TD>person2</TD><TD>person3</TD><TD>person4</TD><TD>person5</TD></TR><TR><TD><FONT color="#FF6600">4.2</FONT></TD><TD>3.9</TD><TD>3.8</TD><TD>3.4</TD><TD>3.6</TD></TR><TR><TD>3.1</TD><TD><FONT color="#FF6600">4.1</FONT></TD><TD>3.6</TD><TD>3.7</TD><TD>3.6</TD></TR><TR><TD>4</TD><TD>3.9</TD><TD>3.8</TD><TD>3.6</TD><TD>3.2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.&nbsp;</P><P>&nbsp;</P> Thu, 08 Jun 2023 19:52:42 GMT Anonymous 2023-06-08T19:52:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Highlight-cell-if-value-is-3-higher-than-next-highest-value/m-p/3275332#M121489 <P>Hi</P><P>&nbsp;</P><P>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.&nbsp;</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>person1</TD><TD>person2</TD><TD>person3</TD><TD>person4</TD><TD>person5</TD></TR><TR><TD><FONT color="#FF6600">4.2</FONT></TD><TD>3.9</TD><TD>3.8</TD><TD>3.4</TD><TD>3.6</TD></TR><TR><TD>3.1</TD><TD><FONT color="#FF6600">4.1</FONT></TD><TD>3.6</TD><TD>3.7</TD><TD>3.6</TD></TR><TR><TD>4</TD><TD>3.9</TD><TD>3.8</TD><TD>3.6</TD><TD>3.2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.&nbsp;</P><P>&nbsp;</P> Thu, 08 Jun 2023 19:52:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Highlight-cell-if-value-is-3-higher-than-next-highest-value/m-p/3275332#M121489 Anonymous 2023-06-08T19:52:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Highlight-cell-if-value-is-3-higher-than-next-highest-value/m-p/3277400#M121614 <P><img /></P> <P>&nbsp;</P> <P>Note that I unpivoted your sample data to make it usable.</P> <P>&nbsp;</P> <P>See attached.</P> Sat, 10 Jun 2023 01:22:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Highlight-cell-if-value-is-3-higher-than-next-highest-value/m-p/3277400#M121614 lbendlin 2023-06-10T01:22:48Z