Forum Discussion

Tlotly's avatar
Tlotly
Icon for Helper V rankHelper V
4 years ago

Lookup value DAX not working

Hi All
 
Please assist. The measure below is returning a blank.  What is wrong with it?
Measure = LOOKUPVALUE(UserAccess[UserName], UserAccess[Email], USERNAME())
 
The structure of the table I'm querying:

 

Thank you

Matlotlo

 
Need Help

3 Replies

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        HI Tlotly,

        I'd like to suggest you create a measure expression to output the current field value and username to confirm if they are stored in the same formats.
        If they are different, you can do changes to the value of the field to keep them using the same format.

        Regards,

        Xiaoxin Sheng