Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Dear all,
Noob here, appreciate your help in advance.
So id like to calculate let's say the density of my warehouse (let's say max capacity 100 units). This max capacity is not included in the data file.
I have a data file of all the actual units in the warehouse, each row of the data file represents 1 unit.
Let's say I have 50 rows of data, my density would be 50/100.
So how could I introduce the value of Max capacity (100) in the calculation? I prefer not to add a column containing the value.
Thank you
This is how my data is.
Solved! Go to Solution.
I got it! It's so easy! Thx!
@amitchandak "100" is my warehouse capacity, which is fixed, would not be changed.
May I know how to create a measure like this?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.