Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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:

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's avatar
    Anonymous
    2 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

  • Anonymous's avatar
    Anonymous
    Not 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.