Forum Discussion
Count values excluding duplicates
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
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
Hi Kelly,
I am new to Power Bi. Can you tell me how to add a measure. I am having a similar issue.
I have accounts payable data and would like to count the number of POs by company. However, I have multiple payments on a PO. Right now my visualization is counting the number of transactions, including duplicates. Can you help?
Thanks!