New measure, Table or Query... Whatever will give these results in power bi.....

[PBI-DEV]

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 ‌ 🤔

[PBI-DEV · Accepted 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... 🙂

[Anonymous]

@PBI-DEV 

Thank you for sharing.😁

Paul Zheng _ Community Support Team