Forum Discussion
sweidlich
Advocate II
Advocate IILegend affecting how filter is behaving
I feel like this should be easy, but Powerbi is not behaving how I am expecting. I have 3 columns of data: 1) UniqueID 2) Location 3) Presence/Absence of Trait (in "yes" or "no"). But some...
From your description it sounds like you want to ignore the Presence/Absence column when doing the distinct count. You could do this with an expression like the following:
CALCULATE( DISTINCTCOUNT( Table1[UniqueID] ) , ALL( Table1[Presence/Absence of Trait (in "yes" or "no")] ) )
d_gosbell
Super User
Super UserFrom your description it sounds like you want to ignore the Presence/Absence column when doing the distinct count. You could do this with an expression like the following:
CALCULATE( DISTINCTCOUNT( Table1[UniqueID] ) , ALL( Table1[Presence/Absence of Trait (in "yes" or "no")] ) )