Forum Discussion
Weighted Average Score
Hi medonication ,
Have couple of problems want to know based on your description and the sample data screenshot:
"here is some small brands existing in only one small country have always good score so they are on top of the list. Score of these brands needs to be divided by the total population choosen"
How to define the 'small brand' and 'small country? What did the population represent?
Maybe you can share more details about this issue and the calcualtion logic clearly for further discussion. You can also consider sharing a simple sample .pbix file without sesentive information.
Sample file and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hope it is clear...