Forum Discussion
Thigs
Helper IV
4 years agoGet Total for Measure?
Hi all! What I've got going on is a list of Aisles (1 - 14) that had a certain number of SKUs bought from each (count('Sample Black Friday'[SKU])). I have a maximum that can be pulled from each a...
Anonymous
4 years agoNot applicable
Hi Thigs ,
Have trouble to follow, please share some sample data and expected result.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Jay
Thigs
Helper IV
4 years agoHi! Thanks so much!
Here is a link to my PBIX file -
https://www.dropbox.com/s/m433iqu9u1o5a5f/Aisle%20Simulation%20Non-Identifying.pbix?dl=0
You can see what I want in the "Test" column - it's 35, but what I want is to show that remainder for all rows, not just the row that has the remainder, if that makes sense. What I want as an end result is to essentially reallocate that remainder to the other aisles that have more room.