AND opeation

[dhavalrg]

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.

[Anonymous]

Hi @dhavalrg, anmolmalviya05, thank you for your prompt reply!

Currently, it is not feasible to use slicers and filters in the dashboard, we can filter a dashboard tile in focus mode, however we can't save the filter.

Or we could only filter the data in report, create a measure as shown below:

MyMeasure = 
IF (
    SELECTEDVALUE('Table'[Behavior:ActionOriented]) = 2 && SELECTEDVALUE('Table'[Behavior:DecisionMaking])= 3,
    1,
    0
)

Then use the measure to filter the table :

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dhavalrg]

Our goal is to attain this outcome by employing a dynamic strategy, which allows us to choose various skill labels, resulting in corresponding outputs.

[Anonymous]

Hi @dhavalrg,

You could create different slicer to  Behaviour:ActionOriented and Behaviour:DecisionMaking columns to filter the report.

[anmolmalviya05]

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 !!