How to Count Distinct Values in a Column

[ljm0zyb]

I need the count column to look like this.

[jppv20 · Accepted solution]

Hi @ljm0zyb ,

Create a column with this formula:

Count = CALCULATE(COUNT('Table'[Week Number]),ALLEXCEPT('Table','Table'[Week Number]))

If I answered your question, please mark it as a solution to help other members find it more quickly.