Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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 ...

Need Help

v-kelly-msft
6 years ago
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