Device ID exists in multiple accounts

[arutkowski]

I have a single table that contains a 'Devices_UID_Value' colum (which is a Unique computer or phone device id). I also have a column which contains a 'file_source_name'. I want to return instances where the 'Devices_UID_Value' match more than one 'file_source_name'.

Similarly, I have a another table with an 'IP_Address' column, and with a 'User_ID" column.  I want to return instances where the 'IP_Address' is associated with multiple 'User_IDs'

Any suggestions?

[Sahir_Maharaj]

Hello @arutkowski,

To return instances where the 'Devices_UID_Value' match more than one 'file_source_name', you can use the following:

DeviceCount = COUNTROWS(
    FILTER(
        SUMMARIZE('Table', 'Table'[Devices_UID_Value], 'Table'[file_source_name]),
        CALCULATE(DISTINCTCOUNT('Table'[file_source_name])) > 1
    )
)

To return instances where the 'IP_Address' is associated with multiple 'User_IDs':

IPCount = COUNTROWS(
    FILTER(
        SUMMARIZE('Table', 'Table'[IP_Address], 'Table'[User_ID]),
        CALCULATE(DISTINCTCOUNT('Table'[User_ID])) > 1
    )
)

Let me know if you may require further guidance.

[arutkowski]

Thank you for the offered solution. It does not appear to work.  I will paste screenshots so you can see.

The first photo shows what happens if I drop the measure onto a table with the two column names in question.

The second photo shows that the underlying data does indeed have matches.

I also tried the IP address formula, but as it is the same formula, I also did not get any results, even though upon manual inspection, there are in fact matches.