ALL & ALLEXCEPT, ALL FUNCTION.. Want to display the overall average in each row

[kelvinbala]

Hi Team, 

The code below works, it calculates the service Level of three different teams, 

Service Level= CALCULATE(COUNTROWS('Call Log'), 'Call log'[CAMPAIGN] = "Inbound", Call Log[Queue TIme (sec)] <= 1) / [Total Inbound Call]

Now the issue is that instead of showing the service level for each team, I don't want to filter by Team 

I have two Tables, Call Log and Teams Table. How can I use the ALL or ALLEXCEPT 

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Measure = calculate([Sevice level],all(Teams[Team]))

Also, modify your Service level measure to

Service Level= divide(CALCULATE(COUNTROWS('Call Log'), 'Call log'[CAMPAIGN] = "Inbound", Call Log[Queue TIme (sec)] <= 1),[Total Inbound Call])