Conditionnal Formating with pure field

[PatrickByGecko]

Hello

I'm trying to have conditionnal Color formating on a simple numeric Field (here underneath CodeProjectID) but the menu panel always propose to have condition on the number of CodeProjectID not the value of CodeProjectID. What am I doing wrong?

[edhans]

Because the value field you are using is not a number, but a field, so it has however many records are in your table. It needs to do Count, First, Max, or something to get to a single, also called scalar, value.

That is why a measure will work as is, a measure always returns a scalar value.

What Power BI is doing is actually creating an implicit measure, like COUNT(Table[YourField]) or MAX, or FIRST, or whatever.

[PatrickByGecko]

Thanks.

IS there anyway to compute a measure for instance from this field to be able to condition on the value itself? For instance New Measure TEST = 0+ CodeProjectID (I tried it does not work).

[edhans · Accepted solution]

Use MAX for this. MAX will return the max value, but both MIN and MAX have a unique characteristic where they will convert a field to a scalar value if there is only one value in your field.

So MAX(Table[CodeProjectID]) will work

[PatrickByGecko]

Thanks a lot, it's working!

[edhans]

Great! Glad my solution helped.