How to show value when selected with other value(s)?

[JustinDoh1]

I am trying to show value(s) when I select more than one value.

I have upload my PBIX file here.

I have this DAX that states that "if "ALI" is selected from tblScore[Location], it displays "ALI", otherwise none.

ALI Cover = IF(SELECTEDVALUE(tblScore[Location]) in {"ALI"},"ALI","")

But, when I select more than one value, nothing would shows up.

How do I modify the exisitng DAX to accomplish that?

Also, I have created three separate DAX for each spot, but is there a way to combine into one DAX expression by chance?

Thanks.

[JustinDoh1]

@shafiz_p Hi Shafiz, Thank you so much for your help.

You DAX is almost working, but I am wondering, is there way for all of three signs show up when

user selects "Select all".

I have uploaded the updated PBIX with three measures (Covers) updated.

Thank you!

[DataNinja777]

Hi @JustinDoh1 ,

My observation is that you do not need to repeat the three boses, and can use ConcatenateX to achieve your required output.  

Cover = 
IF(
    ISFILTERED(tblScore[Location]),
    CONCATENATEX(
        VALUES(tblScore[Location]),
        tblScore[Location],
        ", "
    ),
    BLANK()
)

I have attached a pbix file for your reference.

Best regards,

[JustinDoh1]

@DataNinja777  Thank you so much for your feedback.

I guess due to the spacing issue and alignment to the each parameter, I would need to create separate covers for each.

At this moment, I am trying to find a way for all three signs would show up when users select "Select all".

Please find my latest & updated file here that has three separate measures included.  Thank you!

[shafiz_p · Accepted solution]

Hi @JustinDoh1  Try this:

ALI Cover = 
IF(
    NOT ISFILTERED(tblScore[Location]),
    "",
    IF(CONTAINSSTRING(CONCATENATEX(tblScore, tblScore[Location], ","), "ALI"), "ALI", "")
)

Output:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz