Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX formula issue

Hey guys,    I am having issues with  DAX formula, its a litte tough to explain, but I will try to make the question simple.    Particularly, when I tried to get the list of UDER ID before, when ...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    You could create a measure like:

    measure =
IF ( MAX ( table[fy] ) = 2020, 1, 0 )

    Add column [user id] into a table visual,

    add the measure into visual levle filter of the table above, then select [meaure]=1 in the filter pane and apply it.

    finally, the table visual will only show user id which is from 2020.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey v-juanli-msft ,

Thanks for your reply.

 

I tried that, but it only gave me one value, I assume the MAX value,  but I need the list of the USER IDs. 

 

Thanks, 

Sona

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

You could create a measure like:

measure =
IF ( MAX ( table[fy] ) = 2020, 1, 0 )

Add column [user id] into a table visual,

add the measure into visual levle filter of the table above, then select [meaure]=1 in the filter pane and apply it.

finally, the table visual will only show user id which is from 2020.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.