Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi SBC ,
Try by using this way like by replacing rank with rownumber, i hope it works 

 

  • SBC's avatar
    SBC
    Helper III
    1 year ago

    Hi Anonymous ,

     thanks for responding. The session is actually a measure from one table2, and the user ID is from a different table, which is a column in Table 1. I'm having trouble applying the logic you provided.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Then you can merge the two tables on User ID and then apply the dax which i shared
      or
      else use the related function and try adding the sessions column into table 1 and then apply it will works for you (link for how to apply related : https://youtu.be/8YJyALHRKRY?si=kVrp91C110j6u34d)
      Hope it will work for you
      or else explain it clearly what you are not getting then i will help you