Forum Discussion
Helper VConditionnal Formating with pure field
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?
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
5 Replies
- edhans
Community Champion
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.
PatrickByGeckoThanks.
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
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