Positive, negative totals in a separate cards

[mea]

Hi, 

I have summary table with totals by clients

Client, Total

Client 1, 100

Client 2, -250

Client 3,  50 

Total is a measure that takes in to account different busines logics. 

How to create measure, that shows only positive total measure values by client dimension? 

So, I would be able to have two seperate cards: 

Card 1: Client 1 + Client 3 = 150 (so total for positive clients)

Card 2: Client 2 = - 250 (so total for negative clients) 

Currently pulling Total measure into cards, it results in net Total, so = 100

Thanks! 

[PaulDBrown]

Create measures for each group of values to use in the card visuals using the equivalent to the following (in my example, the base measure is a simple SUM, but use your own measure:

+ve values =
CALCULATE ( [Sum Value], FILTER ( 'Table', [Sum Value] > 0 ) )

-ve values = 
CALCULATE([Sum Value], FILTER('Table', [Sum Value] <0))

to get:

[mea]

Summary table is a visual "table", not an actual table

Actual table:

Client 1, Asset 1, 200

Client 1 Asset 2, -100

Client 2, Asset 1, 500

Client 2, Asset 2, -750

Client 3, Asset 1, 50

So I cannot sum values by "is value>0 or <0."

I need to sum them by client dimension.

Positive amount = If on client level amount is > 0 then amount else 0

[PaulDBrown · Accepted solution]

Ok. In that case, try creating measures equivalent to:

+ve values =
VAR _table =
    ADDCOLUMNS ( VALUES ( 'Table'[Client] ), "_Value", [Sum Value] )
RETURN
    CALCULATE ( [Sum Value], FILTER ( _table, [_Value] > 0 ) )

-ve values =
VAR _table =
    ADDCOLUMNS ( VALUES ( 'Table'[Client] ), "_Value", [Sum Value] )
RETURN
    CALCULATE ( [Sum Value], FILTER ( _table, [_Value] < 0 ) )

[mea]

Worked! Thanks a lot! Cheers! 

[mh2587]

Negative = if(total <=0,total)