Forum Discussion

rpiboy_1's avatar
rpiboy_1
Icon for Helper V rankHelper V
2 years ago

More efficient approach then 'LookupValue'?

I have the following measure written. I'm using LOOKUPVALUE twice to transit two relationships back to the column value I'd like to concatentate together into a string to show in a card. Just wonderi...
rpiboy_1's avatar
rpiboy_1
Icon for Helper V rankHelper V
2 years ago

Sample file with a simple model and example of current DAX Measure.

  • rpiboy_1's avatar
    rpiboy_1
    Icon for Helper V rankHelper V
    2 years ago

    Worth noting, the current functional measure also gets the list of users based on the last date that there were logins, not all users that have logged in historically. This is another important part of the bahavior.

     

    In the vernacular I want to transfer the filter context of the Fact Table (User Activity) to the User List table, but that requires traversing two relationships. Maybe I just need to further modify the 'calculatetable' statement I already have?