The DAX measure we used here is pretty standard:

KIWI QTY = CALCULATE(SUM(Fruits[Quantity]), FILTER(Fruits, Fruits[Fruit] = "KIWI"))

However, it results in a blank evaluation when no Kiws were sold..

We can fix this by Adding a + 0 to the end of the like so:

KIWI QTY = CALCULATE(SUM(Fruits[Quantity]), FILTER(Fruits, Fruits[Fruit] = "KIWI")) + 0

But this results in a non specific formula, that’s where Coalesce come in:

KIWI QTY = COALESCE(CALCULATE(SUM(Fruits[Quantity]), FILTER(Fruits, Fruits[Fruit] = "KIWI")), 0)

or maybe you want a message displayed instead..

KIWI QTY = COALESCE(CALCULATE(SUM(Fruits[Quantity]), FILTER(Fruits, Fruits[Fruit] = "KIWI")), “No Kiwis Sold :(“ )

That looks way better! It’s very specific and outputs a clear ‘no data’ message.