Forum Discussion
AND opeation
Currently we have created the following dashboard. how can we implement the logic to get only 2 as a value in action oriented and 3 as a value in decision making.
Hi dhavalrg, Hope you are doing good!
You can deal with this situation using DAX, you can try below approach:
MyMeasure =
SWITCH(
TRUE(),
SELECTEDVALUE(TableName[ColumnName]) = "Behaviour:ActionOriented", 2,
SELECTEDVALUE(TableName[ColumnName]) = "Behaviour:DecisionMaking", 3,
BLANK() -- This returns BLANK() if the column value is neither "a" nor "b"
)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!