Counting locations where product is out of stock

[Anonymous]

Hi all,

I have created the following DAX formula which counts the number of store locations where a product is out of stock.

Unfortunately the formula isn't very efficient and the dataset is very large (100 million records).

Products OOS =

SUMX (

VALUES ( Stores[Site Key (4 Digits)] ),

COUNTX (

FILTER (

VALUES ( 'Product'[Article Key] ),

[Stock Qty: Trend] <= 0

&& [Ranged Products] <> BLANK ()

),

[Article Count]

)

)

Does anyone have any ideas how this can be optimised?

Thanks

Mike

[Anonymous]

Hi @Anonymous,

Can you please share your sample data

Thanks & Regards,

B V S S