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...
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.