Count duplicate entries once

Use the implicit "Count (Distinct)"  aggregration on these visual fields or create the equivalent measures.

Hi RudolphVan ,

Your solution is great, lbendlin . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

I think you can also Remove Duplicates in Power Query. I create a table as you mentioned.

Then I choose Remove Duplicates. 

Finally it will show you what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.