Forum Discussion
Measure evaluates differently when used as filter on visual?
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?
1 Reply
- amitchandak
Super User
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])
