Forum Discussion
Anonymous
6 years agoNot applicable
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
- jdbuchanan71
Super User
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] )