Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Exclude slicer/filter from measure calculation

Hello

 

I have two arrays that interact with each other. Because of this matrix- 2 is to have a filter like the following

 

now I have a measure

 

 

AnalysisDateAmount a CALCULATE (
SUM ( Table_1[Amount] ),
FILTER (
ALL ( Table_1[File Category] ),
Table_1[File Category] - "Date of Analysis"
))

But the date filter 12/31/2013 is being applied and I am not getting the required result. This filter occurred due to interaction and was not created by me. Is there a way to remove that filter while I calculate the measure.? I can't turn off the interction because of other columns in the table

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

     

    you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.