Use measure in Iterator

Question

Aplogies if this looks like a re-post, I initially accidentally put in under "Community".&nbsp;Relatively new to Power BI and trying to do things that are easy in Excel (guessing I'm not the only one...)&nbsp;I have a table of items a company sells with item dimensions.&nbsp;I'm looking for how many items will fit in a tote (storage box), so that we can best figure out what size tote to use.&nbsp;I have created a measure called Available Volume, based on height, width, length and percentage fill and have these values on sliders, so I can show available volume as a value:&nbsp;&nbsp;&nbsp;&nbsp;I can iterate through all items if I hardcode the tote size into the DAX measure:&nbsp;Items per Tote =SUMX(&nbsp; &nbsp; 'Week 36',&nbsp; &nbsp;&nbsp;ROUNDDOWN(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;DIVIDE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Week 36'[Item Volume]&nbsp; &nbsp; &nbsp; &nbsp;),&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; ))&nbsp;Giving:&nbsp;&nbsp;Yet referencing the Volume of Tote Meause in the iterator blanks out all records in the visual:Items per Tote =SUMX(&nbsp; &nbsp; 'Week 36',&nbsp; &nbsp;&nbsp;ROUNDDOWN(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;DIVIDE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Available Volume],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Week 36'[Item Volume]&nbsp; &nbsp; &nbsp; &nbsp;),&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; ))&nbsp;&nbsp;&nbsp;&nbsp;So, how do I reference Available Volume in that iterator? Is my problem because it isn't related to my table?

freemanz · Answer

try this:&nbsp;Items per Tote =VAR&nbsp;AvailableVolume =&nbsp;&nbsp;[Available Volume]RETURN&nbsp;&nbsp; &nbsp;SUMX(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;'Week 36',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;ROUNDDOWN(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;DIVIDE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;AvailableVolume,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;'Week 36'[Item Volume]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;)&nbsp; &nbsp; &nbsp;)

steve123 · Answer

Thanks for the response.&nbsp;However, I get the same problem, with it returning blanks&nbsp;For info, this works, but is still hardcoding it:Items per Tote = VAR AvailableVolume = 40RETURN&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; 'Week 36',&nbsp; &nbsp; &nbsp; &nbsp; ROUNDDOWN(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DIVIDE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AvailableVolume,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Week 36'[Item Volume]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )

freemanz · Answer

May i see your definition of the measure&nbsp;[Available Volume]?

steve123 · Answer

definition here:&nbsp;Available Volume = ([Tote Length Value] * [Tote Height Value] * [Tote Width Value] * ([Percent Fill Value]/100))/1000000&nbsp;and each of the values are Parameters.&nbsp;There is no relationship between Available Volume and my 'Week 36' table.&nbsp;Am I defining this wrong?Basically, I'm trying to migrate something we've done in Excel over to Power BI and having some great success and looking at creating templates, but I'm wondering whether this is the right way to do particular thing.

Forum Discussion

Use measure in Iterator

4 Replies

Related content

Optimize double iteration measure in DAX

iterator

Replacing values with Iterations

Iterate through a measure

Measure to Dynamically Iterate Through List of Columns