Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate Average except one column

Hi all,   Below is a summary of what i have in my data.  I need to calculate National Avg in the second Table below. My query currently looks like  Avg National = CALCULATE(AVERAGE(Query1[Bill...
Need Help
  • amitjzaveri's avatar
    amitjzaveri
    5 years ago

    Anonymous  Can you try this? It worked for me in one of the scenarios

     

    Avg National = 
CALCULATE(AVERAGE(Query1[Bill Rate]),ALL(Query1[State]),ALLSELECTED(Query1[Division],Query1[Assignment Type],Query1[Speciality]))

     

     

amitjzaveri's avatar
amitjzaveri
Resolver II
5 years ago

Anonymous  Can you try this? It worked for me in one of the scenarios

 

Avg National = 
CALCULATE(AVERAGE(Query1[Bill Rate]),ALL(Query1[State]),ALLSELECTED(Query1[Division],Query1[Assignment Type],Query1[Speciality]))

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitjzaveri  Superb 

 

Thanks a lot..