_Dax Measure for Count of user based on the Access time

[AlanP514]

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

[JoeBarry · Accepted solution]

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