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