Forum Discussion
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...
- 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.
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.