Forum Discussion
Matrix Conditional Formatting based on Field Measure not working
Thank you in advance for your consideration! All details in the image - can't figure out why conditional formatting isn't working. files if desired: https://www.dropbox.com/scl/fi/8ulppt8k982oupje...
Hi BeaudryL
You didn't apply a filter modifier to your overall mean, so it simply returns the average of Response.Value. This results in the average for each combination of Clinician and ID.Q rows, which is essentially the same as your implicit measure of the average Response.Value.
The sample measure below will return the same value for all rows of MENTORS table.
Overall_Mean =
CALCULATE ( AVERAGE ( MENTORS[Response.Value] ), ALL ( MENTORS ) )
Almost there. Looks like it's calculating the 1_SD_Below_Mean measure line by line also? It is should be highlighting red numbers below 3.48. I would need to change that measure also? Thank you so much for your time!
