Rate and Rank with User Input Weighting

[Gorblix]

I am wondering if anyone knows a way to create a rate and rank where the end user can determine the weighting for each category by manually changing the items in red.  I'm using the formula, =G3*F$1+E3*D$1+C3*B$1 , for the Overall Score Column

	0.3333		0.33333		0.33333
Supervisor	Result 1	Rank 1	Result 2	Rank 2	Result 3	Rank 3	Overall Score	Overall Rank
Lindsey	3.5	3	3.4	1	3.9	1	1.66656	1
Rachel	3.7	1	3.3	2	3.1	7	3.33327	2
Deana	3.7	2	3.1	5	3.7	4	3.66657	3
Jamie	3.1	7	3.1	4	3.8	3	4.66641	4
David	3.4	5	3.2	3	3.1	6	4.66647	5
Jason	3.3	6	2.9	7	3.8	2	4.99977	6
Andrea	3.5	4	2.9	6	3.3	5	4.99983	7

[Jihwan_Kim · Accepted solution]

Hi,

I like to suggest creating additional tables and slicers like the attached pbix file.

I tried to create a sample pbix file like below.

If you need more decimal numbers, you can add more rows into the source.

All measures are in the attached pbix file.