Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
Wrap your statement in a FILTER function.
InventOnHand =
FILTER(
SUMMARIZE(
'InventTransBiEntities',
'InventTransBiEntities'[ItemId],
'InventTransBiEntities'[Serial Number],
"Qty", SUM(InventTransBiEntities[Qty])
),
[Qty] > 0
)
Proud to be a Super User! | |
Wrap your statement in a FILTER function.
InventOnHand =
FILTER(
SUMMARIZE(
'InventTransBiEntities',
'InventTransBiEntities'[ItemId],
'InventTransBiEntities'[Serial Number],
"Qty", SUM(InventTransBiEntities[Qty])
),
[Qty] > 0
)
Proud to be a Super User! | |