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

It is not working .

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    6 years ago

    Hi Amit,

     

    not working any of them .