write a Measure to differentiate values in a row

[Anonymous]

Dear Community, 

I have a matrix with : 
(Radif and value are coming from Table1.
Column1,Column2,Column3 are coming from Table2)

I want to show value of matrix based on a these conditions: 
If values in a row are different mark them in blue
If there exist just one value in a row mark it in black
If values in a row are same then mark them in gray

[Icey]

Hi @Anonymous ,

Please check my latest reply in this post: Comparing values in a row.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

If values in a row are different mark them in blue - compare the value against the average value for the row (by Radif)
If there exist just one value in a row mark it in black - compare the value against the sum of values for the row divided by number of columns
If values in a row are same then mark them in gray - all other scenarios, you can set this as the default value