Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

RE: Total Up a calculated column in Power BI 

Nov 09, 2019 02:25 AM
Statistics
0 Favorited
7 Views
1 Files
0 Shares
1 Downloads
Attachment(s)
pbix file
Exclude People who have selected an Item_3.pbix   34.33MB   1 version
Uploaded - Nov 09, 2019

Tags and Keywords

Comments

Nov 11, 2019 02:28 AM

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

Related Entries and Links

No Related Resource entered.