topic Re: Count total client base on condition in DAX Commands and Tips

Count total client base on condition

ReutAtias12 — Thu, 17 Nov 2022 12:26:12 GMT

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 🙂

Re: Count total client base on condition

Jihwan_Kim — Thu, 17 Nov 2022 12:57:55 GMT

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 ) )

Re: Count total client base on condition

ReutAtias12 — Thu, 17 Nov 2022 16:48:30 GMT

Thanks that works!