Measure that responds to slicer

[anwarbi]

Hi,

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.

[V-lianl-msft · Accepted solution]

Hi @anwarbi ,

Try to create a measure like below:

Measure = 
var peer_ = CALCULATE(AVERAGE('Table'[value]),ALLEXCEPT('Table','Table'[peer]))
var vendors_ = AVERAGE('Table'[value])
return peer_-vendors_

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jppv20]

Hi @anwarbi ,

Can you provide some sample data and the desired output?