Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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])
@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])
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |