Forum Discussion
Solved
Power BI count with multiple criterial
Hi All, I have data that consists of 476 unique part numbers that are purchased items. each of the 476 items have either 0 in stock or stock on hand. I want to get a count of these 476...
Ah, I thought Inventory Calgary was a column. Since it's a measure, try:
Count of Items with Stock > 0 = CALCULATE( DISTINCTCOUNT(Dashboard[No.] ), FILTER( Dashboard, Dashboard[Make/Buy] = "Purchase" && [Inv_Calgary] > 0 ) )
I am getting this error
I believe it could be that my Inventory Calgary is a measure adding up 2 bin locations in this warehouse?
Ah, I thought Inventory Calgary was a column. Since it's a measure, try:
Count of Items with Stock > 0 =
CALCULATE(
DISTINCTCOUNT(Dashboard[No.] ),
FILTER(
Dashboard,
Dashboard[Make/Buy] = "Purchase" && [Inv_Calgary] > 0
)
)yes, this is perfect.. thank you so much.. pulling my hair out for a bit before coming here. thanks
You're welcome! DAX is a tricky beast at first.. but eventually it starts making sense and then it's magical 🙂