Forum Discussion

dfort's avatar
dfort
Frequent Visitor
4 years ago
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...
Need Help
  • SteveHailey's avatar
    SteveHailey
    4 years ago

    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
    )
)
dfort's avatar
dfort
Frequent Visitor
4 years ago

yes, this is perfect.. thank you so much.. pulling my hair out for a bit before coming here. thanks

SteveHailey's avatar
SteveHailey
Solution Specialist
4 years ago

You're welcome! DAX is a tricky beast at first.. but eventually it starts making sense and then it's magical 🙂