Forum Discussion
Conditional Formatting not working correctly
Hello community! i am trying to use conditional formatting on a table. I have used background colour based on a field. The field is a DAX with Switch condition. Unfortunately the results seem...
Anonymous , Need to check the measure you have used are you getting consistent value from that. One on the right hand side. I do not see a static value of .44.
Make sure measure on right is using all or allselected
can you share the measure formula
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
The Dax of the measure is as follows:
Image Performance TOP 3% = (CALCULATE(COUNT('E9 Image Attributes'[Response ID]),'E9 Image Attributes'[Value] =10 || 'E9 Image Attributes'[Value] =9 || 'E9 Image Attributes'[Value] =8 ))/[Total Sample]