topic Re: How to show value when selected with other value(s)? in DAX Commands and Tips

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

JustinDoh1 — Sat, 14 Dec 2024 00:38:50 GMT

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

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.

shafiz_p — Sat, 14 Dec 2024 03:35:23 GMT

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

DataNinja777 — Sat, 14 Dec 2024 04:45:51 GMT

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 — Mon, 16 Dec 2024 19:01:38 GMT

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!

JustinDoh1 — Mon, 16 Dec 2024 19:26:50 GMT

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!