Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Guys,
Would you be so kind and help me with weighted Average?
I am very new to measures & DAX so I need your help.
I have Bar chart where I am showing % of KPI against some products however avererage is not ideal as I need weighted average.
Can I do something like sumproduct in excel?
Below is just example of what I need to achive.
Will be this new measure still interactive in my chart?
Many thanks.
Andrej
Solved! Go to Solution.
Hello @v-qiuyu-msft,
I have managed to sort this out. I have used advices sumx formula. My original problem wasn't with formula but with wrong data.
Thank you for offering your help.
Andrej
Hi @AndrejZitnay,
Can you share us the formula how you calculate the Regular Average and Weighted Average? It seems there should be other used data you didn't posted. Please share detail information, so that we can try to write DAX.
Best Regards,
Qiuyun Yu
Hello @v-qiuyu-msft,
I have managed to sort this out. I have used advices sumx formula. My original problem wasn't with formula but with wrong data.
Thank you for offering your help.
Andrej
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |