Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

single value was expected?

I get the below error:       My code in the Role is:   [Key_Customer] IN SELECTCOLUMNS(     FILTER(         'Customer',         LOOKUPVALUE( 'Customer'[Key_Customer], 'Customer'[Lea...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , filter should have true and false , not very clear if this will return true false

 

try like

 

[Key_Customer] IN

SELECTCOLUMNS(

FILTER(

'Customer',

LOOKUPVALUE(

'Customer'[Key_Customer],

'Customer'[Lead_EmpNo],

LOOKUPVALUE(max(Employee[EmpNo]),Employee[NTUserName], USERNAME())

)

)

,"Cust" ,'Customer'[Key_Customer])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    A MAX cannot be added there...