Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

filter a table based on measure

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? 

  • 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] )
    

1 Reply

  • 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] )