Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
foreach part number which has a field associated as IsInStock and it's > 0 then return 1 for only one of them and 0 for the rest... i.e. I need to treat each part number as distinct and if any of the underlying records IsInStock > 0, then I need to add just one for that part number on that particular date
The problem is, the Total IsInStock should be less than the skuCount
It works fine if a date and location are selected like this....
So the previous pictures IsInStock should be something less than 75,511 for D and 13,439 for A... most likely approx. 75-90%
Any help with a calculation of measure is greatly appreciated....
P.S. It's OK if I have to get rid of some filters for the view I need....
Just need a view that will give correct numbers.... Thanks in advance 🤔
Solved! Go to Solution.
Well it seems this is the only solution I was able to come up with using a table
and SQL Data....
Thanks to anyone who was able to at least view this... 🙂
Well it seems this is the only solution I was able to come up with using a table
and SQL Data....
Thanks to anyone who was able to at least view this... 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.