Solved: Filter a column based on the value of another colu... - Page 2

Anonymous · ‎06-12-2020

Hi All,

stupid question.. but I really cannot fix it..

I am trying to distinct count the values in column A excluding the values in column B

The result should be 3... but if I do.. =CALCULATE(DISTINCTCOUNT(Table1[A]);ALLEXCEPT(Table1;Table1[B])) doesn't work.. how should I fix it?

thanks

Simone

Anonymous · ‎06-12-2020

i forget to add formula where

Measure = CALCULATE(DISTINCTCOUNT(TableA[Column1]);FILTER(TableA;NOT(TableA[Column1] in VALUES(TableA[Column2]))))

Filter a column based on the value of another column