Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX conditional on multiple text columns

Hi,   I am looking to create a measure that is conditional on two attributes.    Unfortunately I am not able to come up with the DAX expression that allows me to reference Customer[Group] or Sale...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try like

New Rate = IF(maxx(filter(Customer, Customer[name] =sales[name]),Customer[Group])="B" && Sales[Category]="Equipment", 100% , else Customer[Rate])

 

or

 

New Rate = IF(related(Customer[Group])="B" && Sales[Category]="Equipment", 100% , else Customer[Rate])

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks amitchandak ,

 

The first option almost works, but I cannot reference sales[name] for the filter part, as it is in a different table I believe.

 

Unfortunately the second option is exactly what I had in mind, but I cannot reference either Group or Category.  It only lets me reference measures.