Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
17 | |
14 | |
14 | |
13 | |
13 |
User | Count |
---|---|
19 | |
15 | |
15 | |
11 | |
10 |