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.

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

What it will do is just count the rows in the table where the year is 2020.  If the year is not 2020 the measure will return blank so the rows would not show in your table.  Using the measure is just a way to filter what is shown in the table.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Okay got it. This might not work then, because I have more than one row per participant in my table. 

Thanks, 

Sona

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    It will group duplicate values into a single row so "Bob" would only show once.