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 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.

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.

3 Replies

  • Nithinr's avatar
    Nithinr
    Resolver III
    3 years ago

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

  • 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