How to keep the values of parent category when adding a subcategory to a table

[Camus]

Hi Everybody!

I've been tackling this issue for 3 days now and I can't find a solution. While trying to educate myself on DAX until I figure out the solution myself, I thought that maybe someone can give me a hand.

Background:

I have a list with sales of products (let's say wine) that are categorized by type (white, red, sparkly etc). In another list I have a list of stores that have minimum shelf space described. Based on the percentage of the sales share (KPI consisting of different sales metrics) I should be able todetermine the amount of SKUs of each category that can be put in the store shelves. This I managed to do, but the issue is that when I introduce the products to the powerbi table, the values change. I imagine that the issue is with filtering. Could anyone help me to improve the following formula of the measure seen below?

floor([KPI]*100/calculate([KPI];ALL(Salesdata[Category]))*calculate(MIN(Storespace[Minimumspace]);ALL(Salesdata[Category]))/100;1)

[vanessafvg]

@Camus it would be difficult to help you without seeing what the issue is now vs what you want it to be

please provide screen shots of your data, the error and the expected result