I desperately need help in creating a dax expression.
First of all due to proprietary issue, I wont be able to share any data, but only a dummy data set.
I have a data set like this:
Company KPI1 KPI2
A 2% 3000
B 1.8% 2500
C 2% 4000
I need to calculate weighted average so that will get the result as
((KPI1 of A * KPI2 of A) + (KPI1 of B * KPI2 of B) + (KPI1 of C * KPI2 of C))/(KPI2 of A + KPI2 of B + KPI2 of C)
The challenge is the data is in different related tables and I would have to put a Slicer, whereby the same is calulated either for all the companies (A, B, C) or any one or more of them.
Any help from you guys would be be very helpful.