Explanation of CALCULATETABLE being used as a filter in CALCUATE Function

[moizsherwani]

I have a formula where a table name is being used as the parameter for CALCULATE table but no other filters and this itself is nested within a CALCULATE function acting as a filter, what does it do?

I am referring to the "CALCULATETABLE(Invoice)" here.

=CALCULATE(

SUM(SalesOrderDetail[ExtendedAmountb])-SUM(InvoiceDetail[ExtendedAmountb]),

Product[Product]="Lic-Items", CALCULATETABLE(Invoice)))

Thanks,

Moiz

[v-caliao-msft · Accepted solution]

Hi @moizsherwani,

CALCULATETABLE function evaluates a table expression in a context modified by the given filters. If there is no any filters include in this function, then it will return the oraginal table.

So in your scenario, the CALCULATETABLE(Invoice)) is a filter for CALCULATE function.
Measure = CALCULATE(SUM(Apps[Amount]),CALCULATETABLE('Table 2'))
Measure 2 = CALCULATE(SUM(Apps[Amount]))

Regards,

Charlie Liao