Forum Discussion

qazwsxedc's avatar
qazwsxedc
Helper III
5 years ago

Ignore Outside filter

I have this measure which is tied to 2019-12-31, how to make it ignore the outside filter like Year 2020? Thanks!

 

 

1) Dec 2019 =
CALCULATE(sum(MonthlySum[Balance]),
FILTER(all(MonthlySum[businessdate]), MonthlySum[businessdate]=date(2019,12,31)))
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI qazwsxedc 

    Can you please be more specific with providing required input and output data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi qazwsxedc ,

    What's your expected result? Whether the second table(mark as two) in the below screenshot is what you want? Could you please provide more details(sampledata and satisfied conditions etc.) about your expected result? Thank you.

    Best Regards