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

The thing I'd suggest in this case is to upload a .pbix sample so that me or someone else can check.

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