Forum Discussion
Conditional Formatting in Matrix using the Mean of a Column
I have a Measure called [Cascata Acumulado Rec sobre Total] that is a calculated measure, it shows the acumulated percentage in the Safra variable for the current Month (NOTE: I can`t calculate AVERAGE() of this measure)
In the image below you can see the matrix
I want to paint the background of the cell RED if the value is below the AVERAGE of that Month
So this is what i want to have
I've tried several approaches, but I couldnt figure it out, I know that my conditional formatting measure is something like this:
The thing is, I need to kind of lock the Average just to calculate the AVERAGE of the month, so i can have something like this
So that i can calculate my Conditional Formatting Measure to us in my matrix
- Anonymous2 years ago
Hi Anonymous ,
Below is my table:
The following DAXmight work for you:
Column = IF('Table'[Cascata Acumulado Rec Sobre Total]<'Table'[Average_Measure] , 1,0)The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- AnonymousNot applicable
Hi Anonymous ,
Below is my table:
The following DAXmight work for you:
Column = IF('Table'[Cascata Acumulado Rec Sobre Total]<'Table'[Average_Measure] , 1,0)The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.