Ignoring the slicer Selected value in calculating average - In graph chart

[Anonymous]

Dear All

I am prepering a report , in graph visulatisation , I need to select the company and analyse the performance against other Companies which is not selected , the issue here is when I am calculating averge using measure and filter I am getting average of whole company , how can i get the average of % task completion excluding selected company in the slicer

Date	Support Company	% task completion
Jan	Company A	12
Jan	Company B	60
Jan	Company C	30
Feb	Company A	19
feb	Company B	70
Feb	Company C	40
Mar	Company A	20
Mar	Company B	60
Mar	Company C	30

[amitchandak · Accepted solution]

@Anonymous , Try measure like

calculate(Average(Table[% task completion]), filter(all(Table[company]) , table[company] <> selectedvalue(table[company])))

best is to use an independent company table 

calculate(Average(Table[% task completion]), filter((Table[company]) , table[company] <> selectedvalue(company[company])))

or

calculate(Average(Table[% task completion]), filter((Table[company]) , not table[company] in allselected(company[company])))

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE