Card Value To Show But Only Specific Selections

[DW868990]

Thanks in advance.

I have a card visual which needs to only display it's value based on 1 slicers specific selections.

There are about 8 different combinations of selections the end user could make of this slicer in which the card needs to display, some a single values but majority are specific multiple values that are selected.

For example when Product2 is selected the value needs to show, and also when Product2 and Product3 is selected; but NOT when Product2 and Product4 is. tHere about 8 specific curated scenarios in which if occur the card visual needs to show.

I am struggling with the DAX logic behind this, any advise is appreciated.

[ValtteriN]

Hi,

For multistate conditional logi try using SWITCH + TRUE structure. 

E.g.

Slicer state =

SWITCH(TRUE(),

MAX('Table (7)'[Attribute])="Price 1","Price 1",

HASONEFILTER('Table (7)'[Attribute]), "One value selected",

ISFILTERED('Table (7)'[Attribute]), "Multiple values selected",

"No selection")
The basic logic is the following:

SWITCH(TRUE(),
condition 1, result1,
condition 2, result 2,
...)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[DW868990]

Hi Yes, Thank you.

Getting there I think, but with the above measure how would i hard code in the combinations required.

So for example i want the message only to show when price2, price 3 and price4 is selected by user?