Filter Card visual based on a column from different table

[Anonymous]

Hi Community,

I'm trying to filter a card visual where I have a measure that calculates aggregation of Qty of items. Some items might have negative quantities. I need the card to just show the sum of values where Qty is positive by item. 

Table Visual:
Item	Qty (Measure)
100	30
101	-45
102	25
Required Card:
Qty = 55

Thank you in advance!!

[Anonymous]

That worked. Thank you @amitchandak !!

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

Sumx(filter(Table, Table[Qty] >0 ), Table[Qty])