Forum Discussion

jaco1951's avatar
jaco1951
Helper III
8 years ago
Solved

Problem with date filter when sum

Hi

 

I cannot get the correct sum when trying to sum a group of values where I want to collect the ones that have been updated most recently by week.

 

I have created a filter saying Date = Max(Date), so that when I select a week, I want to sum the newest data for that period.

 

balance_USD = CALCULATE(
SUMX(factTable; 'factTable'[amount_USD]);
FILTER(factTable; factTable[dataSource] = "BANK");
FILTER(cal_Reported; cal_Reported[Date] = [maxDate_Reported]) )

I have two dates for the week I am running, and it sums both... 

 

Anyone who can see what I am doing wrong?

Br Espen

Show and Tell
  • jaco1951's avatar
    jaco1951
    8 years ago

    Seems that I have fixed the issue, still not quite sure how... 

    I changed the MAX(Date) variable, adding a ALLSELECTED filter to it:

     

    maxDate_Reported = CALCULATE(

    MAX(factTable[date_reported]);

    FILTER(ALLSELECTED(factTable);
    factTable[dataSource] = "BANK"))

2 Replies

  • jaco1951's avatar
    jaco1951
    Helper III
    8 years ago

    Seems that I have fixed the issue, still not quite sure how... 

    I changed the MAX(Date) variable, adding a ALLSELECTED filter to it:

     

    maxDate_Reported = CALCULATE(

    MAX(factTable[date_reported]);

    FILTER(ALLSELECTED(factTable);
    factTable[dataSource] = "BANK"))