Forum Discussion

sandee's avatar
sandee
Helper I
6 years ago

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...
sandee's avatar
sandee
Helper I
6 years ago

I am looking for client name where the "Total amount" is greater than "0" No of days,

 

please ignore "cust No"

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

sandee So:

Total Amount = SUMX(FILTER('Table',[Days overdue]>0),[Amt Due])

? 

  • sandee's avatar
    sandee
    Helper I
    6 years ago

    It is not working .

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      sandee - OK, let's back-up. Sample data as text that I can copy. Expected output from said sample data. We are just going to spin our wheels otherwise. If you provide this, I will mock this up in a PBIX file that I keep and get to a working solution.

       

       

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      sandee ,

      in case days overdue is a measure
      calculate(sumx(filter(Values('Working ledger'[customer]),[Days overdue]>0),[TotalSum]), all('Working ledger'))

      calculate(sumx(filter(All('Working ledger'[customer]),'Working ledger'[Days overdue]>0),[TotalSum]))

      calculate(sumx(filter(All('Working ledger'),'Working ledger'[Days overdue]>0),[TotalSum]))

      • sandee's avatar
        sandee
        Helper I
        6 years ago

        Hi Amit,

         

        not working any of them .