Forum Discussion

Ollie2220's avatar
Ollie2220
New Member
6 years ago

Checking for Multiple variables in a list

Hi everyone,   I am trying to use DAX to check for multiple variables in a list. For example:   I have a drop down list with "Banana", "Apple", "Orange", "Kiwi", "Pear" as selectable options whic...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Try something like:

 

Measure = CONCATENATEX(VALUES(Fruits[Names]),",")

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
 
Hi Ollie2220 
Try this.
We also have same requirement.
 
List of Purchasers = IF(ISFILTERED('Sub Group'[Purchaser Name]),CONCATENATEX(ALLSELECTED('Sub Group'[Purchaser Name]),'Sub Group'[Purchaser Name],",",'Sub Group'[PURCHASER NAME],ASC),"All Purchasers")
 
Replace columns and tables with your columns and tables.
 
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar