Measure help

[thesle]

• Totale ticket chiusi = SUMX(FILTER('estrazione_dati 2 ticket','estrazione_dati 2 ticket'[Stato ticket] = "CHIUSO" ),1)  in this measurement I count how many lines have the string "closed" in order to understand the total number of closed tickets

• Media ticket chiusi al giorno = AVERAGEX(SUMMARIZE('estrazione_dati 2 ticket','estrazione_dati 2 ticket'[DATA_CHIUSURA_TK].[Giorno]),'estrazione_dati 2 ticket'[Totale ticket chiusi]) In this measure I calculate the average number of tickets closed per day

• Media ticket chiusi al mese = AVERAGEX(SUMMARIZE('estrazione_dati 2 ticket','estrazione_dati 2 ticket'[DATA_CHIUSURA_TK].[Mese]),'estrazione_dati 2 ticket'[Totale ticket chiusi]) In this measure I calculate the average number of tickets closed per month

• Tempo_medio_presaincarico_ticket = AVERAGEX('estrazione_dati 2 ticket',DATEDIFF('estrazione_dati 2 ticket'[DATA_INIZIO],'estrazione_dati 2 ticket'[data_presa_in_carico],DAY)) in this measure I calculate the average time it takes to process a ticket from the date the ticket is opened

• Tempo medio chiusura ticket = AVERAGEX('estrazione_dati 2 ticket',DATEDIFF('estrazione_dati 2 ticket'[data_presa_in_carico],'estrazione_dati 2 ticket'[DATA_CHIUSURA_TK],DAY)) in this measure I calculate the average time it takes to close a ticket from the date of receipt

 I simply wanted to compare with you and understand whether the calculations seem right to you or not

[lbendlin]

Instead of SUMX(...,1) you can use COUNTROWS(...)

No need to specify the table name for measures.

[thesle]

Thank you very much, what about the other measurements, do they seem correct to you?