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

6 Replies

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