I have a table that displays a row of KPIs as measure values, and I need the values to be color-coded based on the industry standard for that KPI, but each one has a different standard it is up against (for example, one may need to be green if the value is >50, and a other is green if it is <.95. It was easy to get this to work when they were in their own sheets, I used a measure that specified the value based on a formula that I applied to the color filter, but I can’t see a way to do that when the values are displayed using measure values.

Additionally, is there a way to link a different measure to a particular measure value? I have a calculated measure for each KPI that displays in text where that measure falls (Disadvantage, Typical, Advantage, etc.), which again worked fine when they were in their own sheets and I could just display it under the actual value as a mark, but not sure how to do that with measured values.