Forum Discussion
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...
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] )
jdbuchanan71
Super User
Super UserHello 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] )