Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |