Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AlanP514
Helper V
Helper V

_Dax Measure for Count of user based on the Access time

Spoiler
Table 1  
User ID  
123451 Selected from the Slicer
678910 Non Selected
Spoiler
Table 2      
Acess Time  Component Name  Desktop Mobile
09-02-2023 Home 0 3
09-02-2023 Payment  1 0
09-02-2023 Account 0 5
09-02-2023 Loan 1 0
09-02-2023 Details 0 3
08-02-2023 Home 1 0
08-02-2023 Payment  0 0
08-02-2023 Account 1 0
07-02-2023 Home 1 0
07-02-2023 Payment    1
06-02-2023 Account 1  
06-02-2023 Loan   1
06-02-2023 Details 1  
05-02-2023 Home 1  
05-02-2023 Payment    1
04-02-2023 Account 1  
Spoiler
Output  Pivot table            
User Septmber August July June May April
123451 5 3 2 3 2 1

Hai 
Actual data is the 2nd Tag
I am trying to get count of of user based on the login time
In the first box that is the table 1 , from there i have selected one user id
expected output table ie.(3rd) tag is showing each months from the current month how many times selected user logged based on the access time

Appreacite help on this

1 ACCEPTED SOLUTION
JoeBarry
Solution Sage
Solution Sage

Hi @AlanP514 

 

I presume there is userid in Table2?

 

Logins = SUMX(Table2, Table2[Desktop]+ Table2[Mobile])

 

In the Matrix add the Month to the column field and the user to the row and then the measure to the values

 

Thanks

Joe

 

If this post helps, then please Accept it as the solution

View solution in original post

1 REPLY 1
JoeBarry
Solution Sage
Solution Sage

Hi @AlanP514 

 

I presume there is userid in Table2?

 

Logins = SUMX(Table2, Table2[Desktop]+ Table2[Mobile])

 

In the Matrix add the Month to the column field and the user to the row and then the measure to the values

 

Thanks

Joe

 

If this post helps, then please Accept it as the solution

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.