Forum Discussion
Solved
Count Distinct Column B where Column A Match
I need a little help with this one as i have not found an answer that works. I have two columns. Column A Column B Group A Name A Group A Name B Group A Name C Grou...
I would use calculate column, something like
Count Values = CALCULATE(COUNTA(Table1[Column B]), ALL(Table1[Column B]), Table1[Column A]= EARLIER(Table1[Column A]))
Maybe there is better way to calculate, but idea is to have column which you cna use in visual filter.
Hi jvanmeter,
Drag column A to the visual and then use this calculated field formula i.e. measure
=DISTINCTCOUNT(Data[ColumnB])
Now apply a criteria on the measure as > 100
Hi jvanmeter,
Drag column A to the visual and then use this calculated field formula i.e. measure
=DISTINCTCOUNT(Data[ColumnB])
Now apply a criteria on the measure as > 100