Hi,
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.
Thanks,Rohit