Dax to lookup from multiple values

[sgsukumaran]

 I have a DAX filter to see if the user is merchant but want to extend to see if they belong to Manger or Director. Any way to extend this filter?

='Ownership'[Merchant]=LOOKUPVALUE('Ownership'[Merchant], 'Ownership'[UPN], USERNAME())

[v-huizhn-msft]

Hi @sgsukumaran,

If you still have not resolved your issue based on the solution above. Please post some samle data for further analysis. So that we can post DAX which is close to your requirement.

Thanks,
Angelia

[Anonymous]

https://msdn.microsoft.com/en-us/library/gg492170.aspx

The LOOKUPVALUE function can look at as many columns as you want...

[sgsukumaran]

@Anonymous

Thats correct but I want the "OR" condition to be applied. The User can be a mechant or manager or Director

[Anonymous · Accepted solution]

Gotcha.

In that case you will have to get more fancy 🙂

The equivalent of this:

'Ownership'[Merchant]=LOOKUPVALUE('Ownership'[Merchant], 'Ownership'[UPN], USERNAME())

is roughly:
'Ownership'[Merchant]=CALCULATE(VALUES('Ownership'[Merchant]), FILTER(Ownership, Ownership[UPN] = USERNAME()))

so to add more conditions:

'Ownership'[Merchant]=CALCULATE(VALUES('Ownership'[Merchant]), FILTER(Ownership, Ownership[UPN] = USERNAME() || Ownership[FirstName] = "Bob"))