Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
Solved! Go to Solution.
@Anonymous , Try a measure like
Sumx(filter(Table, Table[Qty] >0 ), Table[Qty])
@Anonymous , Try a measure like
Sumx(filter(Table, Table[Qty] >0 ), Table[Qty])
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |