Forum Discussion

tmjones2's avatar
tmjones2
Icon for Helper I rankHelper I
5 years ago

How to Make a Measure Ignore Filters in One Field

I'm trying to get a measure to ignore all filters in one field ('Fact'[RiskRegionKeyDim]). The measure I have below works if you don't use any slicers but if you try to slice on anything it doesn't w...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

tmjones2 removefilters('Fact'[RiskRegionKeyDim])

 

but better to have this filter from RiskRegion table and remove it

  • tmjones2's avatar
    tmjones2
    Icon for Helper I rankHelper I
    5 years ago

    I'm not exactly sure what you mean, what do I replace? Do I still need a FILTER function in there? Seems like it either throws me an error or the result is the same.