Forum Discussion

postke's avatar
postke
Frequent Visitor
2 years ago

Issue getting aggregated summary value with multiple slicers and a parameter filter

To all you PowerBI gurus, I am having trouble figuring out a solution to my problem. Please be gentle, I am a novice… In the attached example (scrubbed), I have three key components… Clients Cit...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please read about REMOVEFILTERS and use that in your measure on the left.

  • postke's avatar
    postke
    Frequent Visitor
    2 years ago

    Thanks but when I try RemoveFilters, it removes all the city based slicers, it does not all me to retain the ones that are required for the aggregated calculation. Removefilters gets me the client rev across all cities, but not a sum inclsive of all the required cities...unless I am using it wrong.