Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ahmedalam
Regular Visitor

Power Query Filteration

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])
                )
1 ACCEPTED SOLUTION
jgeddes
Super User
Super User

Wrap your statement in a FILTER function.

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
SundarRaj
Super User
Super User

Hi @ahmedalam , here's the solution. Thanks

SundarRaj_0-1744119615756.png

 

 

Sundar Rajagopalan
jgeddes
Super User
Super User

Wrap your statement in a FILTER function.

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.