Forum Discussion
Measure based on Column
- Right, so thinking of a measure like:
Measure?
VAR __Type to MAX('Table'[Type])
VAR __RedThreshold - IF(__Type to "Written",.75,.85)
VAR __KPI1 [KPI1%]
Return
IF(__KPI1 <-__RedThreshold,"Red","Green")
You *should* be able to create a new measure that does the coding based upon the Type. You would then use this new measure for your rules. But, impossible to be specific because there are large gaps in required information like what are the rules that you are trying to implement for the color coding?
Hi Greg_Deckler ,
many thanks for the response!
Here more information:
KPI1% is between 0% and 100%.
If the type is Written:
Values between 0% and 75% should be colored (background) in red.
Values between 75.01% and 100% should have green background
If the type is Voice:
Values between 0% and 85% should be colored (background) in red.
Values between 85.01% and 100% should have green background
Many thanks in advance!!
- Right, so thinking of a measure like:
Measure?
VAR __Type to MAX('Table'[Type])
VAR __RedThreshold - IF(__Type to "Written",.75,.85)
VAR __KPI1 [KPI1%]
Return
IF(__KPI1 <-__RedThreshold,"Red","Green")Hi @Greg_Deckler ,
you are just awesome!!
Thank you very much - it works!
Do you have an idea of what it would look like (the formula) if you have 3 channels - Voice, Written, Chat?
- Awesome! Glad it works!! 🙂