Conditional Formatting in Matrix using the Mean of a Column

[Anonymous]

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:

Color =

VAR ValorAtual = [Cascata Acumulado Rec sobre Total]

VAR AvgMonth = [Medida MediaMes]

RETURN

IF(

    ValorAtual < AvgMonth,

    "Red",

    "White"

)

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

[Anonymous · Accepted solution]

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.