Display "Multiple" in a card when multiple projects are selected

[Anonymous]

Hi everyone...

I would like to have a card visualization display the Project ID selected in a page filter from a column with non-distinct values, or the text, "Multiple" if more than one distinct project is selected. For example; if the user selects Project ID "1" from a page filter created from the column below, "1" will be displayed in the card. If they select Project IDs "1" and "2," "Multiple" will be displayed in the card. Any thoughts on how the DAX should be written?

Project ID
1
1
1
2
3
4
4
4
5

[mussaenda · Accepted solution]

Hi @Anonymous ,

You can try this measure and drag to your card.

Measure = IF(HASONEVALUE('Table'[Project ID]),SELECTEDVALUE('Table'[Project ID]),  "MULTIPLE")

Hope this helps.

[Anonymous]

Perfect. Thank you.

[ryan_mayu]

@Anonymous 

maybe you can try

Measure = CONCATENATEX(DISTINCT(ALLSELECTED('Table')),'Table'[Project ID],",")

plse see the attachment below

[Anonymous]

Thank you. I'll keep this solution in my back pocket if the requirement calls to list the multiple Project IDs selected in a card instead of the word, "Multiple." 👍