filter a table based on measure

[Anonymous]

I have a margin created by What_if parameter. 

I have three measures: 
m1= [a]

m2= [b]

m3= ([a]+[b]) *margin/100

m3 is responding to the margin selection.

Now, I want a list of names. When I create a table and put Name and m3 in the table, it works perfectly, something like below:

name1 --> m3 for name1

name2--> m3 for name2

etc

When m3 is calculated per person, for some people it is negative and for some people it is positive. 

Now, I want to have two card visuals which show the sum of m3 when it is negative per person and sum of m3 when it is positive, how can I do this? 

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

Give these a try

Positive M3 =
SUMX ( FILTER ( VALUES ( YourTable[Names] ), [M3] > 0 ), [M3] )

Negative M3 =
SUMX ( FILTER ( VALUES ( YourTable[Names] ), [M3] < 0 ), [M3] )