Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 🙂
Solved! Go to 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
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks that works!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
11 | |
10 | |
8 |