Forum Discussion

Menvf's avatar
Menvf
Frequent Visitor
3 years ago

Using different relationships in a iterative function

Hi Guys!

 

I need to use different relationships within the same iterative function.

What I need is the below calculation, however where the all('Invoice Line');all('Purchase Order') only is applied to [Finished demand per bag]

 

calculate(sumx(mainReseptitSQL;mainReseptitSQL[Finished demand per bag]*([CM Kg price after reduced]/[CM Yield])*[CM Sold No of Bags]);all('Invoice Line');all('Purchase Order')
 
Thank you in advance
Need Help
Tips and Tricks

2 Replies

  • Menvf's avatar
    Menvf
    Frequent Visitor
    3 years ago

    I tried making a measure of the first

    [Finished demand per bag]

     

    So it went like this

    CM Finished demand per bag = calculate(sumX(mainReseptitSQL;mainReseptitSQL[Finished demand per bag]);all('Purchase Order');all('Invoice Line'))

     

    Then I nested it so it looked like this.

    TEST CM Total Cost Sold Bags = calculate(sumx(mainReseptitSQL;mainReseptitSQL[CM Finished demand per bag]*([CM Kg price after reduced]/[cm Yield])*[CM Sold No of Bags]))

     

    Each individual measure gives me a the expected value. However, when I put them all in the same measure I get unexpected results as if the first filter context in the first measure wasn't there.

     

     

     

     

  • Menvf's avatar
    Menvf
    Frequent Visitor
    3 years ago

    Another attempt was made, what is weird is that the filtercontext added in the variable is removed when used in the return. All measures work like intended when used seperately.

    TEST CM Total Cost Sold Bags = 
var Finished_demand_per_bag = calculate(sumx(mainReseptitSQL;mainReseptitSQL[Finished demand per bag]);all('Invoice Line');all('Purchase Order'))

return 
sumx(mainReseptitSQL;Finished_demand_per_bag *([CM Kg price after reduced]/[CM Yield])*[CM Sold No of Bags])