Column for Distinct count of a column as per another columns

[Anonymous]

Hi everyone,

Excuse my trivial request 🙂

I am attempting to create a column that counts distinct values as per another column 

i.e Distinct fiscal_quarter by project_number

project_number	fiscal_quarter	Result Column
PS0267526	2021-Q1	3
PS0267526	2021-Q1	3
PS0267526	2021-Q1	3
PS0267526	2020-Q4	3
PS0267526	2020-Q4	3
PS0267526	2020-Q4	3
PS0267526	2020-Q3	3
PS0277388	2019-Q4	5
PS0277388	2019-Q4	5
PS0277388	2020-Q1	5
PS0277388	2020-Q1	5
PS0277388	2020-Q1	5
PS0277388	2020-Q2	5
PS0277388	2020-Q2	5
PS0277388	2020-Q4	5
PS0277388	2020-Q4	5
PS0277388	2020-Q4	5
PS0277388	2021-Q1	5
PS0277388	2021-Q1	5
PS0277388	2021-Q1	5

Appreciate your help!

Thanks,

[az38 · Accepted solution]

Hi @Anonymous 

= CALCULATE(DISTINCTCOUNT(Table[fiscal_quarter]), ALLEXCEPT(Table, Table[project_number]) )