Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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]   ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

For these two tables, you need to create relationships between them, then create a column in the Collection table.

(Billing)  (Collection)

related = RELATED(Billing[Key])

 

Then create such a measure

 

Measure = CALCULATE(SUM(Collection[Amount]),FILTER(Collection,Collection[Key]=Collection[related]))

 

 

Best Regards

Maggie