Split values by different levels

[SebSchoon1]

Hi Guys!

I'd like to create a report which give me a kind of What if.

In fact I'd like Power BI to provide proposition on stock allocation on one item reference splitted by multiple Sizes.

I give an example

In this example,

I'd like power BI to split The total Quantities by reference  "MAXVAN"  Which is 3 here.

1 Qty in size 10=4  in Stock 015

1 Qty in size 24=2  in Stock 015

1 Qty in size 35=1  in Stock 015

I'd like to share thes 3 sizes according to [Ranks] By [Code DEPOT]

Which means 

One quantity in Stock 010

One quantity in stock 040

One quantity in stock 015

I'm not able to manage it by using RANKX

i don't no if there's a way to achieve this?

here a link to the sample file

https://we.tl/t-EfrMQDvURw

Cordialy

[v-luwang-msft]

Hi  @SebSchoon1 ,

How to get the number in red?Still not clearly.

Best Regards

Lucien

[SebSchoon1]

Hello 🙂 these are only sizes to be considered as strings with no other interests.

Like XS. S  M L XL for clothes 🙂 

I would like to share one quantity by CODE ARTICLE  by warehouse.

But share these according to the available quantities by size.

In this example it will always be one quantity by size 

Which in total makes 3 quantities by item.

And I would like to split these items by each warehouse available (which have a rank) 

Hehe 😊