Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Question : Each client id connected with how many unique Ip address.
Result:
Sample dataset:
User Id ip
821408 | 103.94.137.249 | |
821408 | 103.94.137.249 | |
821408 | 103.94.137.249 | |
821408 | 103.94.137.249 | |
821408 | 103.94.137.249 | |
821408 | 103.94.137.249 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
821450 | 157.33.36.95 | |
821453 | 106.215.56.25 | |
821453 | 106.215.56.25 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
821023 | 49.36.32.161 | |
821023 | 49.36.32.161 | |
821023 | 49.36.32.161 | |
821023 | 49.36.32.161 | |
821023 | 49.36.32.161 | |
821023 | 49.36.32.161 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
821444 | 27.59.159.136 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
821453 | 106.215.56.25 | |
821453 | 106.215.56.25 | |
821453 | 106.215.56.25 | |
821023 | 49.36.32.161 | |
821023 | 49.36.32.161 | |
821023 | 49.36.32.161 | |
773567 | 157.45.112.132 | |
821023 | 49.36.32.161 | |
773567 | 157.45.112.132 | |
821408 | 103.94.137.249 | |
821023 | 49.36.32.161 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
773567 | 157.45.112.132 | |
821023 | 49.36.32.161 | |
821023 | 49.36.32.161 | |
821408 | 103.94.137.249 | |
773567 | 157.45.112.132 | |
821444 | 27.59.159.136 | |
821453 | 106.215.56.25 |
Solved! Go to Solution.
Hi @SIBI1998
Please refer to attached sample file with the proposed solution
Unique IP Filter =
COUNTROWS (
CALCULATETABLE (
VALUES ( 'Table'[IP] ),
ALLEXCEPT ( 'Table', 'Table'[User ID] )
)
Hi @tamerj1 I tried distinct count its not working, not getting appropiate result.
@SIBI1998
Please clarify further what result are you getting VS what result are you expecting.
. If im clicking on Slicer user id, then it shows user id with same Ip address And i don't know in which user id have unique Ip address. So for now i have to click randomly in slicer to check the which user-id have unique ip address.
---------------------------------------------------------------------------------
Result:
You can see here. One user-id having 2 unique ip address. So this Result I want see in my report. Only those user-id having unique ip address. For now it shows all. I tried Distict Count its not working. So expecting some DAX formula to work.
Hi @SIBI1998
Please refer to attached sample file with the proposed solution
Unique IP Filter =
COUNTROWS (
CALCULATETABLE (
VALUES ( 'Table'[IP] ),
ALLEXCEPT ( 'Table', 'Table'[User ID] )
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |