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
Icon for Super User rankSuper User
6 years ago

Anonymous 

You can do a measure that will only return a value when the year = 2020, something like this.

2020 count = CALCULATE(COUNTROWS(YourTable),YourTable[FY] = 2020)

Then you put the names in the matrix and apply this measure as a filter on the matrix and set it to 'Is Not Blank' 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello jdbuchanan71 , 

 

Thanks for your quick response. 

 

USER ID is not the only identifer I have in the table, I also have applications, and one user can have a few applications. 

 

Does this mean this function will get the count of application rows?

 

Thanks, 

Sona

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper 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
        Icon for Super User rankSuper User
        6 years ago

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