Forum Discussion

Avia's avatar
Avia
Frequent Visitor
7 years ago

view duplicate in dashboard



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

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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