Forum Discussion

sgsukumaran's avatar
sgsukumaran
Icon for Resolver II rankResolver II
9 years ago
Solved

Dax to lookup from multiple values

 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'[M...
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    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"))

     

sgsukumaran's avatar
sgsukumaran
Icon for Resolver II rankResolver II
9 years ago

Anonymous

 

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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"))