Forum Discussion
Calculate with Sum Function
Hi All, I am trying to apply the formula to get "total Amt Due" for customer based on the "No of Days above then 0", but i am doing drag and drop it is not working, please can you guide where i a...
Total Amount=CALCULATE (SUMX(FILTER('Table',[Days overdue]>0),[Amt Due]),ALLEXCEPT('Working Ledger'[Cust Name])