Forum Discussion
Helper IICalculate between displayed tables
Super UserHi MyWeeLola ,
For this you need to do the following:
- Unpivot the campaing table so that you have the following setup
- Do a relationship between the subject and the campaing:
- Add the following measure:
Weighted Value =
SUMX(
ADDCOLUMNS(
'Campaign',
"Weigt", RELATED(Subject[Weighting])
),
'Campaign'[Value] * [Weigt]
)
Check PBIX file attach.
Helper IIsomeone accepted this as the solution, but it did not fix the original problem. I went to an external resource to fix it as nothing anyone posted here resolved the issue. However i am appreciative of people trying to help.
- MFelix
Hi MyWeeLola ,
What is the problem, I apologize for missintreperting the question. Can you please elaborate on what is the question at hand.
To what I can understand you want to have the calculation based on the weighted values, and the solution I gave you does that calculation.
Is there any issue with the unpivot of the tables? What is not matching your needs?
I see that the last values are not macthing the result you shared but I believe is because I copied the information incorrectly for line 10.
I have also unmarked the answer to be correct since you refer that is not the solution (other user on the community can accept answers and probably that is what happened).
- MyWeeLola
Thank you for the response. You were the closest, however I could not get your solution to work.
The final solution involved a variation of what you put down which used a filter on the table and using ==. I had to go to an external resource to purchase the solution. However if I had more time with your solution I suspect we would have got there.
Given that here are similatrities in your solution, ill mark it as the solution.
Have a good day
Lola