Forum Discussion

Efp's avatar
Efp
New Member
3 years ago

Measure filter free

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

1 Reply

  • AlanFredes's avatar
    AlanFredes
    Icon for Resolver IV rankResolver IV
    3 years ago

    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!