Aggregation in context

[Lukasz_Lyszczak]

Dear Community,

I'm trying to solve the problem with agregation in context. Have looked throug lot of posts in forum, unfortunatel haven't found solution.

My data model includes 3 bases. Main AD with all categories (t_item). MPS and BOM are related (multiple to one) to AD (MPS_t_item --> AD_t_item and BOM_t_mitm --> AD_t_item). MPS contains als column with dates and qunatities (t_oqan) for all categories.

I'm trying to sum all quantities divided by days or months for each subcategory (BOM_t_sitm).

I see that relation is working cause when I put into matrix category, subcategory and qty results are ok and changing according to chosen period of time.

Unfortunately when I'm deleting main category from matrix, agregation is not working properly and for each subcategory I'm receiving total sum of qty for all categories.

I was trying multiple mesures with difrent summing functions (found in this forum) unfortunately witho positive result.

Thanks for your help.

Regards, Łukasz

[Lukasz_Lyszczak · Accepted solution]

Update. Have found the solution:

Demand = CALCULATE(SUM(MPS[t_oqan]),FILTER(AD,AD[t_item] in DISTINCT(BOM[t_mitm])))