DAX Query to return all SKUs with more than >3 available units for each store.

[andreas789]

Hello, I need help writing a DAX query that will return all SKUs that have more than 3 units of available stock in each Branch Code.

Since I will apply some IF functions for some product category, filtering the tables prior to creating the dashboard, won't help.

[amitchandak · Accepted solution]

@andreas789 , Try a measure like

countx(filter(summarize(Table, [SKU], "_1", distinctCOUNT(Table[Branch_code]), "_2", calculate(distinctCOUNT(Table[Branch_code]), filter(Table, Table[Unit_available_stock] >3))), [_1] =[_2]), [SKU])