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 

what about

DISTINCTCOUNT ( 'Table'[IP Address] )

 

  • SIBI1998's avatar
    SIBI1998
    Helper I
    3 years ago

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

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

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

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