Forum Discussion

Lukasz_Lyszczak's avatar
Lukasz_Lyszczak
Frequent Visitor
3 years ago
Solved

Aggregation in context

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...
Need Help
  • Lukasz_Lyszczak's avatar
    Lukasz_Lyszczak
    3 years ago

    Update. Have found the solution:

     

    Demand = CALCULATE(SUM(MPS[t_oqan]),FILTER(AD,AD[t_item] in DISTINCT(BOM[t_mitm])))
Lukasz_Lyszczak's avatar
Lukasz_Lyszczak
Frequent Visitor
3 years ago

Update. Have found the solution:

 

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