Creating a custom column based on a distinct count

[LeahGJ]

Hi.  

I have a hugggeee set of data with duplicated Purchase order transaction. I want to create a new column in the data set to count number of purchase order numbers. 

Thanks 

[v-jayw-msft · Accepted solution]

Hi @LeahGJ ,

You could use Dax formula:

Column = DISTINCTCOUNT('Table'[Column1])

Best Regards,

Jay

[TomMartens]

Hey @LeahGJ ,

please take the time to create a pbix file that contains sample data but still reflects your data model, upload the pbix file to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

Describe the expected result based on the sample you created.

Regards,

Tom