Count total client base on condition

[ReutAtias12]

Hi All,

I'm trying to count the amount of times a client login with the same user

and then count the total client that had only one user in three months 

client id	login date	user
1	17/11/22	A
1	16/11/22	B
1	15/11/22	A
2	17/11/22	C
2	16/11/22	j
3	07/10/22	Z

i tried to use sumarize but it didnt work

pls help 🙂

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, or how your desired outcome of the visualizations look like, but please try something like below and the attached pbix file.

Expected result measure: =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            DISTINCT ( Data[client id] ),
            "@countusers", CALCULATE ( COUNTROWS ( DISTINCT ( Data[user] ) ) )
        ),
        [@countusers] = 1
    )
)

[ReutAtias12]

Thanks that works!