Filter on Calculate Measure Not Working

[Firdaus17]

Hello Guys, I need solution about my problem,

FYI, I have two table there are AR table and Calendar table, with relationship AR[rev_date] and Calendar[date] and slicer based on Calendar table.

I create a measure "aging < 10 days1" to calculate AR-EndBalance with filter agingdays6 < 10 days, but AR-EndBalance with  agingdays6 >= 10 still include in "aging < 10 days1".
This is detail of my measure :

AR-End Balance = CALCULATE([Invoice-Charges-Allocated>0],FILTER(ALL('Calendar'),'Calendar'[Date]<=MAX('Calendar'[Date])))

Aging <10 Days1 = CALCULATe([AR-End Balance], FILTER(AR,[aging days6] < 10))

Please help my problem if anyone know the solution.

Thanks.

[Anonymous · Accepted solution]

Hi @Firdaus17 

The ALL() Function will remove all filters. You can try the following measure

AR-End Balance = CALCULATE([Invoice-Charges-Allocated>0],FILTER('Calendar','Calendar'[Date]<=MAX('Calendar'[Date])))

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Firdaus17]

@Anonymous 

Thank you for your answer, I was change my DAX measure with your Measure, but the report still same.
May you cheking my report, I already create report in page 1 but the aging days is static not dynamic if I click the slicer, and then I create new report in page 2 with dynamic aging days, but the value of each aging days  group unsuitable. I want values of report by period and by tracking code are same in page 2 like page 1. This is link for the file https://drive.google.com/uc?export=download&id=1ib9_FAPtjXBFRG0Gve_HbCCI-qKBj5bx.

Thank You

[Nithinr]

Check this measure "Invoice-Charges-Allocated>0"  if are you doing ALL(AR table) in that