Forum Discussion
Calculation base on multiple criteria
Hi everyone, I need your help with a special case that I am working with. I need to create a calculation , this is a multiplication base on multiple criteria. 1. I have a table called "tariffs" ...
Hi:
You can put this calulated column in your Consolidation table, after you change data type of Vendor No. to "whole number",
Cost = LOOKUPVALUE(Tariffs[Tariff Amount], Tariffs[Vendor No.], Consolidation[Vendor],Tariffs[Service],Consolidation[Service])
Then this measure for total amount:
Total Amount = SUMX(Consolidation, Consolidation[No. Services] * Consolidation[Cost])
I hope this helps.