Help with measure in Power BI

[Anonymous]

I am struggling a little bit to figure out how to get Power BI to calculate a measure. Everything I have tried so far doesn't calculate correctly. I need weighted average that would be shown on a card and calculated in Excel as 

(Region 2 NPS number for spring 23 for Customer Web Platform + Region 2 NPS number for Spring 23 for Customer Mobile platform + Region 2 # of responses for Spring 23 for Customer Web Platform + Region 2 #of responses for Spring 23 for Customer Mobile Platform) / ( Region 2 # of responses for Spring 23 for Customer Web Platform + Region 2 #of responses for Spring 23 for Customer Mobile Platform). 

I realize this may be a lot of filters I need to use in the measure but for some reason I cannot get it to calculate. I have tried doing filters on the actual card and in the measure. I attached a picture of the spreadsheet to help understand. Please Help!  

[khaledHabib90]

Hello, please try the following steps

1- create a new calculated column in the table view to get the weight of each row, the formula for the the weight would be [# no of responses] / calculate(sum([# no of responses]) , all(your table name))

Step 2 create a measure using Sumx

Weighted average = sumx( your table name, NPS x "the new calculated column

[Anonymous]

Hi, this doesn't give me the answer I need. It gives me extremley low numbers like 0.86 when the WA should be 26. In excel the original excel file the WA is calcualted as below 

I rearranged the data so that I can do it in Power BI automatically but it is the same data.