Forum Discussion
Challenge - Iterating measure
I am working on a cost follow up of labor for a production company. I am having a real challenge defining a measure so it works like I need it. One of the reports I want to build should display the...
Menvf , try if this can work
Total Cost =
SUMX(
Summarize('Invoice Line', 'Invoice Line'[Customer.CustomerCategoryName], 'mainReseptitSQL'[ItemCode], 'mainReseptitSQL'[ComponentItemCode]),
[Total Labor Cost for Semi-Finished Products] * [CM Sold No of Bags]
)