Forum Discussion
Solved
Measure based on Column
Hi, I have the following issue: I have a matrix which looks like this: So the types here are the types of communication - Written or Voice. So I will have a KPI1% under the ...
- 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 ,
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")
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!! 🙂