Forum Discussion

SIBI1998's avatar
SIBI1998
Helper I
3 years ago
Solved

Required Dax Function

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 8214...
  • tamerj1's avatar
    tamerj1
    3 years ago

    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's avatar
SIBI1998
Helper I
3 years ago

. 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's avatar
tamerj1
Community Champion
3 years ago

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