Measure evaluates differently when used as filter on visual?

[markazali]

I have a measure that's:

totaldiv = DISTINCTCOUNT(Emp[divNo])

It's intended to count the different divisions in a dataset. When I use it in a card, I'm seeing the right value (e.g. 5).

When I apply the measure to a filter on visual, and use "greater than 1", all the slicers items are hidden. I dropped it down to "greater than 0" and the items are shown. This tells me the slicer filter evaluates the same measure as 1 instead of 5.

Is there something I'm missing about using a measure this way?

[amitchandak]

@markazali , Visual filter will use row context, and card do have row context so result are different

to get same result try with visual column

Sumx(Filter(Summarize(Emp, dim[col1], Dim2[Col2], "_1", DISTINCTCOUNT(Emp[divNo])), [_1] >1), [_1])