cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## 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?
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Create a Summarize Table using Median - Error Varian type

Hi @rdmoren ,

You may use  MEDIANX function:

MEDIANX ( SLA_BcaEmpresas, [Días] *1.0 )

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support Team

## Re: Create a Summarize Table using Median - Error Varian type

Hi @rdmoren ,

You may use  MEDIANX function:

MEDIANX ( SLA_BcaEmpresas, [Días] *1.0 )

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Frequent Visitor

## Re: Create a Summarize Table using Median - Error Varian type

It works! Thak u so much.

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!