Forum Discussion

LeahGJ's avatar
LeahGJ
Frequent Visitor
5 years ago
Solved

Creating a custom column based on a distinct count

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 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi LeahGJ ,

     

    You could use Dax formula:

     

    Column = DISTINCTCOUNT('Table'[Column1])

     

     

    Best Regards,

    Jay

     

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi LeahGJ ,

     

    You could use Dax formula:

     

    Column = DISTINCTCOUNT('Table'[Column1])

     

     

    Best Regards,

    Jay