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]))