Calculate a sum with filter from another page

[MCacc]

Hello, 

I'm trying to calculate a sum where is filtered for the max day I can find in my period of dates. The issue is, my filter condition comes from another table. 

I tried this:

TOTAL= CALCULATE(SUM(TABLE1[HRS]);FILTER(TABLE2;RELATED(TABLE2[DAYS_PERIOD]) = MAX(TABLE2[DAYS_PERIOD])))

And it gives me this error message:

"The column 'TABLE2[DAYS_PERIOD]' either doesn't exist or doesn't have a relationship to any table available in the current context."

But the tables are indeed connected

Do you guys have any idea why this happens?

[v-lili6-msft · Accepted solution]

hi  @MCacc 

Do you want to create a calculate column or a measure?

If you want to create a measure, Just adjust the formula as below:

TOTAL= CALCULATE(SUM(TABLE1[HRS]);FILTER(TABLE2;TABLE2[DAYS_PERIOD] = MAX(TABLE2[DAYS_PERIOD])))

If you want to create a column, this formula need to used in TABLE1, In TABLE2, adjust the formula as below:

TOTAL= CALCULATE(SUM(TABLE1[HRS]);FILTER(TABLE2;TABLE2[DAYS_PERIOD]=MAX(TABLE2[DAYS_PERIOD])))

Regards,

Lin

[amitchandak]

Try like

TOTAL= CALCULATE(SUM(TABLE1[HRS]);FILTER(TABLE2;(TABLE2[DAYS_PERIOD]) = MAX(TABLE2[DAYS_PERIOD])))