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...)
I have a table of items a company sells with item dimensions.
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.
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:
I can iterate through all items if I hardcode the tote size into the DAX measure:
try this:
Thanks for the response.
However, I get the same problem, with it returning blanks
For info, this works, but is still hardcoding it:
May i see your definition of the measure [Available Volume]?
User | Count |
---|---|
92 | |
32 | |
32 | |
17 | |
13 |
User | Count |
---|---|
99 | |
28 | |
21 | |
16 | |
15 |