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

answer is :

SUMX(FILTER('Raw Data','Raw Data'[Days overdue] >=0),'Raw Data'[Amt Due ])