Ranking/ preferences questions

Hi Anonymous ,

The calculation is based on Value * Count of Values 

So base location has value  3, 5, 2, 3 ,5 , 4.  Value comes to 5*2 + 4*1 + 3*2 + 2*1 = 22 (See the pbix by filtering baselocation in the data view)

Now since 5 is least preferred,  base location will get the highest preference i.e the bar of base location will be highest which is what you do not want as base location is least preferred and should have the smallest bar. 

Thus new value just reverses your values i.e 5 becomes 1 and 1 becomes 5 . Thus a new Value coumn was calculated. This will give you the base location value as 14.

Value become 22 if you put Value in the visual below. Become 14 when New Column is put in the image below.

But Calculation is on weighted average.

Thanks and Regards,

Harsh Nathani