Measure Help

[GorD]

I have two tables one lists a Bill of Material, which has parent parts and components nos(which repeat) and component qtys. There are also some quantity modifiers that will add an additional requirement for expected losses etc. I have a measure that calculates the total required for each component

I have a second table that lists the components and facts about them - the main one being price

I need a measure ( which i'm struggling with) to show the cost of the components for each Parent part

So my pivot table would have

Parent Part, component part, calculated qty of components required, calculated cost of those components

Can't quite get this too work, but feel it should be easy

Help appreciated

Thanks

 

[Matt Allington]

Re: EOQ and Pansize

Yes MAXX does have a row context - all X functions do.

This formula will return the MAX in a column

=MAXX(myTable,myTable[Value])

It will iterate over myTable and find the maximum value in the Value column. But it is returning the maximum value in the column, not the maximum between 2 columns.