Forum Discussion
Count values excluding duplicates
Hi, As part of a separate issue, I had to split a column in my data set by delimiter. This has caused the duplication of much of the data by creating new rows. E.g., I have Column A and Column ...
Hi Anonymous，
What you need is to create a measure as below:
Measure 2 = var _t=DISTINCT(ALLNOBLANKROW('Table'[Column A],'Table'[Column B])) return SUMX(_t,'Table'[Column B])Then you will see as below:
For the related .pbix file,you can turn to the URL below: https://microsoftapc-my.sharepoint.com/:u:/g/personal/v-kellya_microsoft_com/EZTY-6ZX5_9HnH_p3Ix_qI0BzQF2i4CPRodwCIKZHmMVqg?e=WVFOjb
Best Regards,
Kelly
Anonymous ,
Refer below screen shot for your reference and expected out value 209.
Power Query EditorExpected output
Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!