view duplicate in dashboard

[Avia]

Hi,

I am new to power bi and just learning how to use it.

I have a report connected by ODATA and I would like to create a dashboard where i can see only duplicate listings according to a specific column.

For example I have the following columns NAME ADDRESS PHONE and i want to view only those listings that have the name show up more then once (in separate rows).

An additional level would be if I have a few columns with phone number and i want to find duplicates across the file. If one row shows a phone number that appears in another (not necessarily in the same column).

Hope this is clear.

TIA,

Avia

[v-yuta-msft]

Hi Avia,

So your requirement is to achieve the phone number of which has duplicate rows? You can create a measure using DAX format like pattern below and check if it can meet your requirement:

Result =
VAR count =
    CALCULATE ( COUNT ( table[phone] ), ALLEXCEPT ( table, table[phone] ) )
RETURN
    IF ( count <> 1, MAX ( table[phone] ), BLANK () )

Regards,

Jimmy Tao

[Stachu]

can you share sample data?