Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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 calc...
Need Help
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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