Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Administrator

## 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
Administrator
Super User

Hi,

Share the link from where i can download your PBI file.  Ensure that you already have the table/matrix there already.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Administrator

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
https://www.linkedin.com/in/excelenthusiasts/
Administrator

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
https://www.linkedin.com/in/excelenthusiasts/
Administrator

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

Thanks a lot

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors