Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter on Calculate Measure Not Working

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 cr...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous 

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous 

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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