topic Re: Required Dax Function in DAX Commands and Tips

Required Dax Function

SIBI1998 — Thu, 16 Mar 2023 13:36:21 GMT

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

Re: Required Dax Function

tamerj1 — Thu, 16 Mar 2023 13:36:56 GMT

Hi SIBI1998

what about

DISTINCTCOUNT ( 'Table'[IP Address] )

Re: Required Dax Function

SIBI1998 — Fri, 17 Mar 2023 04:50:57 GMT

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

Re: Required Dax Function

tamerj1 — Fri, 17 Mar 2023 04:53:49 GMT

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

Re: Required Dax Function

SIBI1998 — Fri, 17 Mar 2023 05:53:28 GMT

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

Re: Required Dax Function

tamerj1 — Fri, 17 Mar 2023 09:44:58 GMT

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

Re: Required Dax Function

SIBI1998 — Tue, 21 Mar 2023 05:10:05 GMT

thanks tamerj1