Solved: How to Count Distinct Values in a Column

Anonymous · ‎12-09-2021

I need the count column to look like this.

jppv20 · ‎12-09-2021

Hi @Anonymous ,

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.

jppv20 · ‎12-09-2021

Hi @Anonymous ,

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.

How to Count Distinct Values in a Column