How to use distinctcount formula when adding a new column

[ryan_mayu]

Hi ,

I have a sample data below. I want to count the number of BU for each ID. Could you please let me know how to use DAX to create the new column that I highlighted?

Thanks in advance.

[PattemManohar · Accepted solution]

@ryan_mayu Please try this as a "New Column"

Count = CALCULATE(DISTINCTCOUNT(Test81Count[BU]),ALLEXCEPT(Test81Count,Test81Count[ID]))

[ryan_mayu]

@PattemManohar,

Thanks for your help. It works.