cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## a measure that sum positive values only in a Cart

Hi Guys.

I'm really Confused!!!

I have a table like this:

 ITEM_CODE NEED INVENTORY_QTY MISS_0 ITM_1 100 50 50 ITM_2 200 10 190 ITM_3 35 100 -65

I want to create a measure that converts negative values to zero.

I need to sum of [MISS_0] column in a cart and it should show 240 not 175.

and I need to use measure and not calculate column because I have other filters that using of calculate column does'nt helpful.

Now my solution is using filter on this visual(Table) that filters Positive values but this way can't help me cause we cant filter measure with single value in a Cart.

I need a measure just sum positives or in the best way converts to zero.

Thanks.

1 ACCEPTED SOLUTION
Resolver III

This measure

`Measure = CALCULATE(SUM('Table'[MISS_0]),FILTER('Table','Table'[MISS_0]>0))`

2 REPLIES 2
Helper I

so what if i have a table with a measure in it, and i want the same effect (a card with all negative amounts from measure summed and a cart with positive summed). Then above doesn't work on measures i noticed.

So i have WIP calculated in a measure. THis measure takes all revenue minus all costs per project. Now i want to sum all negative WIP amounts.

If i use :

CALCULATE(Measure[WIP], FILTER(Measure, Measure[WIP]>0))

it doesn't do anything. I get same amounts for debet and credit...(where ofcourse i use < and >)
Resolver III

This measure

`Measure = CALCULATE(SUM('Table'[MISS_0]),FILTER('Table','Table'[MISS_0]>0))`

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.