Required Dax Function

[SIBI1998]

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

[tamerj1]

Hi @SIBI1998 

what about

DISTINCTCOUNT ( 'Table'[IP Address] )

[SIBI1998]

Hi @tamerj1 I tried distinct count its not working, not getting appropiate result. 

[tamerj1]

@SIBI1998 
Please clarify further what result are you getting VS what result are you expecting.

[SIBI1998]

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

[tamerj1 · Accepted 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] )
    )

[SIBI1998]

thanks @tamerj1