Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
can you share sample data?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |