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.

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