Compare measure to column, conditional formatting

[Syndicate_Admin]

Good afternoon.

I can't calculate so that of an average I calculate it with a target value of a table and I put it in conditional format, I tell you:

I have calculated the average of a series of indicators and in a table I have for some of those indicators a series of target values to see if they are met, I need you to compare the average with the value and tell me if or not it is not met, or a conditional format.

According to the indicator the comparison will be for < or >

Greetings and thanks.

[MFelix · Accepted solution]

Hi @Aguirre ,

According to the information I'm seeing you need to do something similar to:

Comparision = IF( [Promedio] < SUM(Table[Objective]), 1, 0)

I assume your Objective is the column on the model then just use the 1 and the 0 to make your condittional formatting.

[v-yalanwu-msft]

Hi，

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem

[v-yalanwu-msft · Accepted solution]

Hi, @Syndicate_Admin 

You could create a measure by the following formula：

condiional =
IF ( MAX ( 'Table'[Promedio] ) < 'Table'[Objetivo2], "Green", "Red" )

Then apply conditional formatting: you could choose the background or font color.

The final output is shown below:

If it does not make sense, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best Regards,
Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thiago_bs01]

Using the same exemple. How can I do a conditional formatting comparing promedio's avarege and objetivo's avarege? 

[MFelix · Accepted solution]

Hi @Aguirre ,

According to the information I'm seeing you need to do something similar to:

Comparision = IF( [Promedio] < SUM(Table[Objective]), 1, 0)

I assume your Objective is the column on the model then just use the 1 and the 0 to make your condittional formatting.

[Syndicate_Admin]

Hello and thank you for the answer.
Several problems, I have empty cells and this way I would put them as a 0, and then as the field varies the comparison, it could be <o>, I'm thinking of adding an additional column to control that.

[MFelix]

You can control that on the IF measure itself.

Can you share a small sample and expected result for each line?

[Syndicate_Admin]

Good morning and sorry for the delay, I have finally changed the idea and solved it with a meter, since I have seen it easier. thank you very much for the help.

[Aguirre]

Hi and thanks for the answer.
Several problems, I have empty cells and in this way I would put them as a 0, and then according to the field the comparison varies, it could be <or>, I am thinking of adding an additional column to control that.