Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Menvf
Frequent Visitor

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
2 REPLIES 2
Menvf
Frequent Visitor

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])

 

 

Menvf
Frequent Visitor

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.

 

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.