Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
Is there a way to filter out duplicates in this table? Thank you in advance.
Sample:
Solved! Go to Solution.
Hi, @houston39
Based on your description, I created data to reproduce your scenario. It works properly. The pbix file is attached in the end.
Table:
Result:
Could you show us more details about the problem?
Best Regards
Allan
Hello @houston39 ,
there are ways to filter out duplicates. But please be a little bit more specific.
Do you want to filter out duplicates of VENDORID? Or duplicate rows, like VENDORID, DOCAMNT, Year, Month, Day are exactly the same?
How should the result look like?
As you are already using a table the duplicates are usually already summed up.
Best regards
Denis
Hi Denis,
Sorry about that. Example - if the values are the same in the rows:
VendorID DocAmt Day Month Year
00100 500.00 10 03 2021
00100 500.00 10 03 2021
Will display as
VendorID DocAmt Day Month Year
00100 500.00 10 03 2021
I hope this helps. Thank you.
Hi,
To your visual, drag VendorID, Day, Month and Year to the visual. Write this measure
=min(data[DocAmt])
Hi, @houston39
Based on your description, I created data to reproduce your scenario. It works properly. The pbix file is attached in the end.
Table:
Result:
Could you show us more details about the problem?
Best Regards
Allan
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |