Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
6 years ago
Solved

Average formula

Hi,   Need help with AVERAGE formula,   I would like to calculate below condition,   ID                   ServiceName        %Value     --> Column Name 1                             A         ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi damit23183 ,

    Could you please mark this post as Answered since the problem has been resolved by yourself? Thank you.

     

    Best Regards

    Rena

d_gosbell's avatar
d_gosbell
Super User
6 years ago

You could use an expression like the following to ignore all filters on the table, except for the Service Name

 

Avg = CALCULATE(average('Table'[%Value]), ALL(), VALUES('Table'[Service Name]))
  • damit23183's avatar
    damit23183
    Microsoft Employee
    6 years ago

    Thank you for responding back.

     

    Your formula is usefull but some how drilldown option is not working. 

     

    For example: when i choose service A i should only see value from Service A. 

     

    Looks like its little complicated. Let me send full explanation with screen shot.

     

    Thanks