Show only rows with values

[JNM]

I have a powerpivot table set up and would like to show only rows the QtyShort measure has a value. I tried

=if(QtyShort<>0,qtySlslnLessPkgLn,QtySlsLnLesPkgLn-QtySlsLnLessPkgLn)

but all it does is sit there with the blue circle when I try to add it to the pivot table. Is there a better way to handle this?

As I'm unable to upload attachments, I'll try and show it. I want to only see the first line, not the last two.

ShipDate ShipName ItemNo QtySlsLnLessPkgLn QtyShort
1/1/15 Johns Sales AAA 12 12
BBB 12
CCC 12