Measure filter free

[Efp]

Hello team

I'm looking to create a table with a column that shows all tha accumulate sales, an another with the sales of the month, I have a filter date that applies to all report, but the issue is that I need the accumulate measure need that be filter free it's means the value doesn't change whit the filter date, any idea?

regards

[AlanFredes]

Hi Efp,

With the information you have provided, it seems like you need to use the REMOVEFILTERS DAX function in your calculation to separate the accumulated measures from the date filter.

You can find more information regarding that function here: https://learn.microsoft.com/en-us/dax/removefilters-function-dax

If you need more help let me know and if possible provide some sample data to work with.

Did I answer your question? Mark my post as a solution!