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] ...
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.
Dear Ross,
Wow will it works by creating the measure sum(CollectionAmount)in Billing table?