Forum Discussion
Measures based on Lookup
Dear all, I have two tables Collection and Billing . Collection: Key Amount Billing: Key Now i want to calculate sum(Amount) based on the condition Collection[key]=Billing[key] ...
Dear Ross,
I want to use it as a KPI.
I tried like this
CALCULATE (
SUM( 'Collection'[Amount]),
FILTER ( Collection, Collection[key] = Billing[key] )
)
but i am getting error
Will still work as a KPI, your table relationship will handle all of the filter contexts. Using the calculate statement with the filter is not doing anything.