Forum Discussion

ryan_mayu's avatar
ryan_mayu
Super User
7 years ago
Solved

How to use distinctcount formula when adding a new column

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.

 

Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    ryan_mayu Please try this as a "New Column"

     

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

2 Replies