cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

## Define median of grouped and non-recurring data

Friends, how are you doing?

I have the following problem and I would like to have your help.

I have a base where you have the Id_cliente, the code of a product that the customer bought and the amount that he bought. In many cases the customer repeats the purchase of that product, although sometimes he does it with different quantities.

I am needing to determine the median of each product consumed (code), for which I first group it to the code per client so that it adds the total of each one, and then I apply the median. The problem I have with that function is that it only returns the median of those customers who had consumption, and if the client did not consume that product does not take it into account, when I should put value 0.

I share capture, to see if they understand a little more.

Base original

Base originalBase original

Product grouping by customer

Agrupando producto por cliente. Me calcula la mediana sobre esos valores.Grouping product by customer. It calculates the median on those values.

Intended result

Formato que necesito.Format I need.

Can you think of a solution!?

M

7 REPLIES 7
Super User

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com

Nice day. Attached the file

I need a table where if the product was not consumed put a 0, having that could determine the median correctly.

Thanks a lot!

Super User

Hi,

I get an error when i click on that link.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Back, I just checked that the previous one didn't go up. Thank you

PBI File

Super User

See if this measure works

``Mediana_cantidad 1 = MEDIANX(generateall(values(Tabla_precio[Código]),values(Tabla_precio[PRECIO UNITARIO ÚLTIMA COMPRA])),min('Consulta_consumo'[Cantidad_]))``

Regards,
Ashish Mathur
http://www.ashishmathur.com

Attach back the link, to see if it can now be viewed

Thanks a lot

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors