Calculate with Sum Function

[sandee]

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 am doing mistake. many thanks for your help.

[sandee]

answer is :

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

[Anonymous]

@sandee 

Total Amount=CALCULATE (SUMX(FILTER('Table',[Days overdue]>0),[Amt Due]),ALLEXCEPT('Working Ledger'[Cust Name])

[Greg_Deckler]

@sandee - Very difficult to understand. You could try:

Debt Overdue Days >0 =
  CALCULATE([TotalSum],FILTER(ALL('Working ledger'),[Days overdue]>0)

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. 

[sandee]

Greg, you are right i should have provided more information for this , sorry for this.

below is an example table : i am applying to get "Total Amount" which is above then "0" Dys from "Debt Overdue Days" on client basis.

i hope i am clear this time. thanks in advance

[Greg_Deckler]

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

[sandee]

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

please ignore "cust No"

[Greg_Deckler]

@sandee So:

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

? 

[sandee]

It is not working .

[amitchandak]

@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]

Hi Amit,

not working any of them .

[Greg_Deckler]

@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.

[sandee]

hi Greg,

link for my sample data.

https://drive.google.com/file/d/1y5D0j94Y3PrDeUCd5Or7tEgEtNzW25eH/view?usp=sharing