Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with page level interactions - formula help

I have a lookuptable called 'Users' with UserID and user name and dateActivated . I have another table ('loginactivity') that has userID and userLogins and date. They are connected via userID and a c...
Need Help
  • RMB's avatar
    RMB
    6 years ago

    In that case, simply add just the logins count measure to the filter on the matrix table.

     

    Login count measure:

    Logins = CALCULATE(COUNT(User_Login[UserID]), FILTER(User_Login, [Action] = "Login"))

     

    Login measure on the matrix filter list and set to is not blank:

     

    And a date selected on the graph that is filtering the matrix to just those users that had a login on that day:

     

  • RMB's avatar
    RMB
    6 years ago

    Just to make sure I understanding correctly, you want a DISTINCT user count?

     

    If you create a measure using the distinct count on the UserID column on the User_Login table you can actually put the AppVersion and count of users in a matrix and not require any further actions to filter.

     

    Count of Users = CALCULATE(DISTINCTCOUNT(User_Login[UserID]), FILTER(User_Login, [Action] = "Login"))

     

    Let me know if that answers the question. 

     

RMB's avatar
RMB
Resolver II
6 years ago

Create a new measure that checks if UserID on the logins table is filtered, if it is, then return the count measure you created otherwise return 1. Now on the filters for the matrix visual add that newly created measure and set it to is not blank. 

 

Also worth noting that the graph should be filtering the matrix if the graph is using any columns from the UserID table.

 

 

 

Table Filter = IF(ISFILTERED(User_Login[UserID]), [Logins], 1)

 

 

 

 

 

Sample of a user selected on the graph

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RMB what you gave me did the opposite of what I was looking for, I want to be able to click the graph and filter the userID matrix. Your solution lets me filter the graph when I click on the UserId matrix. Can you please advise how I would do the opposite? I am inclined to think this is a formula issue but I am unfamiliar with what to do 

 

  • RMB's avatar
    RMB
    Resolver II
    6 years ago

    What is your axis on the graph? The above is only necessary if you're graphing with an axis from the login activity table. Do you have a sample screenshot you could share?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      RMB my axis is date from a calendar table (also a shared table) 

       

      • RMB's avatar
        RMB
        Resolver II
        6 years ago

        In that case, simply add just the logins count measure to the filter on the matrix table.

         

        Login count measure:

        Logins = CALCULATE(COUNT(User_Login[UserID]), FILTER(User_Login, [Action] = "Login"))

         

        Login measure on the matrix filter list and set to is not blank:

         

        And a date selected on the graph that is filtering the matrix to just those users that had a login on that day: