Lookupvalue + Sum column values in different table

[CD1]

Is it possible to do a “lookupvalue” in a measure from a column in a different table specified by a range and to sum that range? Are there other options?

[v-shex-msft · Accepted solution]

Hi @CD1,

Please use calculate with filter functions to instead lookupvalue, I don't think 'lookupvalue' can suitable for your requirement.

For example:

Sum from other table =
CALCULATE (
    SUM ( table[value] ),
    FILTER (
        ALL ( table ),
        table[date] >= FIRSTDATE ( table2[date] )
            && table[date] <= LASTDATE ( table2[date] )
    )
)

Regards,
Xiaoxin Sheng

[dgkallan]

Thanks for supplying this. When I'm using this solution, the problem I run into is that it appears to ignore my page filters. Is this a solution other than ALL?