Forum Discussion
Create a Summarize Table using Median - Error Varian type
I want to creat a summarize table that contains the average and the median of a variable. The problem begins when I start to calculate the median, it shows a message "The DAX expression for calculated table 'Cumplimiento SLA' results in a variant data type for column 'Mediana Días'. Please modify the calculation such that the column has a consistent data type.". The Dax is:
Cumplimiento SLA =
SUMMARIZE(
FILTER(SLA_BcaEmpresas,SLA_BcaEmpresas[ETAPA] = "TOTAL SLA NEGOCIO")
,SLA_BcaEmpresas[MES]
,SLA_BcaEmpresas[(ORDEN) MES]
,SLA_BcaEmpresas[TIPO OPERACIÓN]
,"Promedio Días", AVERAGE(SLA_BcaEmpresas[Días])
,"Mediana Días", MEDIAN(SLA_BcaEmpresas[Días])
)
I read that this is because the "MEDIAN" is a varint type for the column, so some people to force the column to return a double value put a "*1.0" but in this case I tried and shows other error message "The MEDIAN function only accepts a column reference as the argument number 1."
What could do i do?
