Forum Discussion

Steve123's avatar
Steve123
Frequent Visitor
3 years ago

Use measure in Iterator

Aplogies if this looks like a re-post, I initially accidentally put in under "Community".   Relatively new to Power BI and trying to do things that are easy in Excel (guessing I'm not the only one....
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

try this:

 

Items per Tote =
VAR AvailableVolume =  [Available Volume]
RETURN
    SUMX(
        'Week 36',
         ROUNDDOWN(
              DIVIDE(
                  AvailableVolume,
                  'Week 36'[Item Volume]
              ),
          0
        )
     )
Steve123's avatar
Steve123
Frequent Visitor
3 years ago

Thanks for the response. 

However, I get the same problem, with it returning blanks

 

For info, this works, but is still hardcoding it:

Items per Tote =
VAR AvailableVolume = 40
RETURN
    SUMX(
        'Week 36',
        ROUNDDOWN(
            DIVIDE(
                AvailableVolume,
                'Week 36'[Item Volume]
            ),
            0
        )
    )
  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

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

    • Steve123's avatar
      Steve123
      Frequent Visitor
      3 years ago
      definition here:
       
      Available Volume =
      ([Tote Length Value] * [Tote Height Value] * [Tote Width Value] * ([Percent Fill Value]/100))/1000000
       
      and each of the values are Parameters.
       
      There is no relationship between Available Volume and my 'Week 36' table.
       
      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.