I inserted a measure which is a text field. but now i am not able to conditional format this measure.
COnditional formatting is not allowing me to select this measure.
Please help !!
i am using below formula for measure
_Final_status = if(CONTAINS('Raw Dump KPI Dashboard','Raw Dump KPI Dashboard'[_Status],"Not Met"),"Not Met",if(CONTAINS('Raw Dump KPI Dashboard','Raw Dump KPI Dashboard'[_Status],"Partially Met"),"Partially Met",if(Not(CONTAINS('Raw Dump KPI Dashboard','Raw Dump KPI Dashboard'[_Status],"Met")),"Out of Scope","Met")))
In above , results are like "Not Met" , "Met" or "Out of scope"
so they are text.
Now i want to conditionally format this measure but i am not able to select the measure.
COnditional formatting is not allowing me to select this measure.
Please help !!
i am using below formula for measure
_Final_status = if(CONTAINS('Raw Dump KPI Dashboard','Raw Dump KPI Dashboard'[_Status],"Not Met"),"Not Met",if(CONTAINS('Raw Dump KPI Dashboard','Raw Dump KPI Dashboard'[_Status],"Partially Met"),"Partially Met",if(Not(CONTAINS('Raw Dump KPI Dashboard','Raw Dump KPI Dashboard'[_Status],"Met")),"Out of Scope","Met")))
In above , results are like "Not Met" , "Met" or "Out of scope"
so they are text.
Now i want to conditionally format this measure but i am not able to select the measure.
Last edited by a moderator: