I have created the below measure, so that if i select a 'vendor name' from the drop down slicer, it should subtract the average score (of the selected vendor from the slicer) from the peer average score (the second part of the measure which adds a filter of related peers- which are also a group of vendors).
The result that i am getting however is incorrect as it only gives me the average score of the selcted vendor in the output and does not consider subtractraction.
I think this measure needs to add some variable in the begining so that the measure responds to the selected vendor from the slicer.
Score deviation with peer avg. = AVERAGE(Sheet1[Score])- (CALCULATE(AVERAGE(Sheet1[Score]), Sheet1[related Peers]<>""))
Your help will be appreciated.