cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kirti_agarwal28
Frequent Visitor

Need to calculate weighted average based on derived values.

Hi All,

There is a scenario as: 

                  Input Data
Question categoryQuestionRating
A1Q11
A1Q11
A1Q11
A1Q12
A1Q12
A1Q12
A1Q13
A1Q13
A1Q13
A1Q13
A1Q10
A1Q10
A1Q21
A1Q21
A1Q22
A1Q22
A1Q22
A1Q22
A1Q23
A2Q13
A2Q13
A2Q13
A2Q14
A2Q14
A2Q14
A2Q20
A2Q20
A2Q21
A2Q21
A2Q22
A2Q22
A2Q22
A2Q22

 

Calculation and output will be like below:

                               Output Calculation
  RatingWeightCalculationFinal Output
A1Q1131*3=3 3+6+12/10 
A1Q1232*3=6  
A1Q1343*4=12  
A1Q100   
A1Q2121*2=2 2+8+3/7
A1Q2242*4=8  
A1Q2313*1=3  
       
A2Q1333*3=9 9+12/6
A2Q1434*3=12  
A2Q2000  
A2Q2121*2=2 2+8/6
A2Q2242*4=8  
1 REPLY 1
amitchandak
Super User IV
Super User IV

@kirti_agarwal28 , Try a measure like

divide(calculate(sum(Table[Rating]), filter(Table, Table[Rating]>0)),calculate(count(Table[Rating]), filter(Table, Table[Rating]>0)))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors