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 appli...
Need Help
Tips and Tricks
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.