SUM by item and seprate positive and negative result

[Maln]

Hi,

I need some help with measure 😑.

I have a problem creating a measure where I can summarize transactions by item number and then use the result for items that have negative value and in another measure positive value. It is important to show positive and negative values separately, becouse I would like to use this measure in visual as Card.

In the table, I have managed to resolve this issue, but I need to use it in a Card where I couldn't get value for positive and negative separately

Example (Items can appear multiple times with different values. The value must be summerized by items and then sum the positive values and negative values separately)

Item No.	Quantity	Value
642010	2	1000
642010	-1	-500
656132	5	1500
689033	-7	-570

Positive value would be 2000

Negative value would be -570.

Thank you all for your help and answers

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Item value only positive: =
SUMX (
    FILTER (
        ADDCOLUMNS (
            DISTINCT ( Data[Item No.] ),
            "@values", CALCULATE ( SUM ( Data[Value] ) )
        ),
        [@values] > 0
    ),
    [@values]
)

Item value only negative: = 
SUMX (
    FILTER (
        ADDCOLUMNS (
            DISTINCT ( Data[Item No.] ),
            "@values", CALCULATE ( SUM ( Data[Value] ) )
        ),
        [@values] < 0
    ),
    [@values]
)