Forum Discussion

rennda's avatar
rennda
Frequent Visitor
7 years ago

Calculate single value against average with multiple filters

Hello everybody,

 

i hope you can help me with my actual issue:

 

I want to calculate the average of AZ_IN_MIN per category by the following code. I did this with  "ALLEXCEPT". But, there are additional two more filters i have to set. It should only build the average from Tickets within "Ticket Category 5 or 6" and tickets which are closed by a defined group of names. 

 

The shown table is already filtered by category and name. But the calculated average is wrong. In case of model bizhub C458 the average should be 44,25..

 

 

AZ AVG = CALCULATE(AVERAGE(Ticket_Kennzahlen_table[AZ_IN_MIN]); FILTER(ALLEXCEPT(Ticket_Kennzahlen_table;Ticket_Kennzahlen_table[Model]); Ticket_Kennzahlen_table[ticket_group] = 5 ||6 && Ticket_Kennzahlen_table[Name (Group)] = "varV"))

THANKS FOR HELP