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