Forum Discussion

sandee's avatar
sandee
Icon for Helper I rankHelper 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...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

sandee Still not quite clear. So, if that is the source data, what is the expected output?

sandee's avatar
sandee
Icon for Helper I rankHelper 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
    Icon for Community Champion rankCommunity Champion
    6 years ago

    sandee So:

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

    ? 

    • sandee's avatar
      sandee
      Icon for Helper I rankHelper I
      6 years ago

      It is not working .

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity 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.