Power Query Filteration

[ahmedalam]

Dear Experts,

I have create one table through DAX and need to show only those data which has more than 0 value in QTY. Can you please guide.

InventOnHand =

            SUMMARIZE(

                'InventTransBiEntities',

                'InventTransBiEntities'[ItemId],

                InventTransBiEntities[Serial Number],

                "Qty", SUM(InventTransBiEntities[Qty])

                )

[SundarRaj]

Hi @ahmedalam , here's the solution. Thanks

[jgeddes · Accepted solution]

Wrap your statement in a FILTER function.

InventOnHand =
            
FILTER(
SUMMARIZE(
'InventTransBiEntities',
'InventTransBiEntities'[ItemId],
'InventTransBiEntities'[Serial Number],          
"Qty", SUM(InventTransBiEntities[Qty])
),
[Qty] > 0
)