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(D...
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"))

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"))

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi jaco1951,

     

    Glad to hear that you have resolved by yourself.

     

    Regards,

    Yuliana Gu