Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I have a list of lot numbers (in a table with other data) and I wanted to make a table visual that calls out the ones that have duplicate entries. Is there a way in New Measures or anything else that will return a list of duplicate entries???
I'm sorry if that was confusing, but please help!!
Thank you!
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @sy898661,
Add a table visual and then select the columns that you want to highlith the duplicates and on the summarization select count then just order your table by that counted column.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix,
Can you expand on that a little bit? I have created a table visual that contains the column in which there is repeated data, when I change it to Count it just shows how many data entries there are in total.
Thanks!!
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsGot it, thank you!!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |