Forum Discussion
Solved
Multiply values in two tables
Hi, I'm pretty new to PowerBI and struggling with how I multiply across two tables. I have a list of clients and their sales in one one table, and then I have a list of clients and the agent who ...
Hi hjg_123 ,
Please try:
Measure = SUMX(Agents,CALCULATE(SUM(TXNs[Value]),FILTER('TXNs',[Clients]=EARLIER(Agents[Clients])))*[Share])Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
