Forum Discussion
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 ...
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.
Okay got it. This might not work then, because I have more than one row per participant in my table.
Thanks,
Sona
jdbuchanan71
Super User
Super UserIt will group duplicate values into a single row so "Bob" would only show once.