Forum Discussion
Calculate with values from different tables
Hello Community, (big thanks already for the endless answers i got by browsing this forum!) Here is my problem - i want to create a measure that would output the total rebate in the example belo...
Many thanks for your help - i realized that by wanting to simplify my case, i misled the helpers like you 😞
Could you please have a look at the new diagram i just published to explain the exact case.
I could not execute the lookupvalue as you suggested due to this "3 tables " chain.
cheers!
Hi newbie74
Why don't you merge table orders and table turnover on column orders and then create the measure which i have suggested in previous comment
incase if you don't want to merge.
measure=Sumx('orders',related(Turnover[orders])*relatedtable(Customer[Rebate]))
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.