Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to avoid MONTH filter in table -

Hi Team   Below is the snapshot of my data   And below is the table I have genrated in PowerBI   Full Year Sales = CALCULATE(SUM(Sales[SALES]), FILTER(Sales,Sales[YEAR]=SELECTED...
  • Anonymous's avatar
    Anonymous
    4 years ago
    Full Year Sales =
    CALCULATE(SUM(Sales[SALES]),
    REMOVEFILTERS(Sales[MONTH]))
     
    Above was the solution I tried and it worked like charm. Thanks for your help.
ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous ,

Just choose this particular slicer not to filter your table:

  • click on the slicer
  • choose Format tab
  • click Edit iteractions
  • hover over the table
  • choose None option

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have tried this also. but still when I am selecting months, measure is changing and showing values for months only. not for years