Forum Discussion
PatrickByGecko
Helper V
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...
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
PatrickByGeckoHelper V
Helper V
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
Community Champion
Community ChampionUse 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.