Total Doesn't seem to apply the filters

[msantillan]

Hi can anyone explain why the total is still the same even if I applied a Filter on a measure.

The left side is just the column without filters, while the right side is the filtered one. You can see that the negative data is already blank but it still returns the same total:

Here is the measure I used:

Grand Total 2 =

var CLNTNME = FIRSTNONBLANK('Reference December AUM'[CLIENT_NAME],1)

return if(SUM('Reference December AUM'[MKT_VALUE_USD])<0,BLANK(),SUM('Reference December AUM'[MKT_VALUE_USD]))

[amitchandak · Accepted solution]

Try like

Grand Total 2 =
var CLNTNME = FIRSTNONBLANK('Reference December AUM'[CLIENT_NAME],1)
return
calculate(SUM('Reference December AUM'[MKT_VALUE_USD]),filter('Reference December AUM','Reference December AUM'[MKT_VALUE_USD])>0))

[msantillan]

@all Thank you for the replies, @amitchandak 's solution was the one that worked for me. 

[ImkeF]

you need an iterator-function for the (sub) totals to be correct

How about this?:

Grand Total 2 =

SUMX(
    VALUES('Reference December AUM'[CLIENT_NAME],

    if(CALCULATE(SUM('Reference December AUM'[MKT_VALUE_USD]))<0,

        BLANK(),

        CALCULATE(SUM('Reference December AUM'[MKT_VALUE_USD]))
)

[az38]

Hi @msantillan 

its difficult to answer without full data model nd data example but I guess it could be solved by using CALCULATE() over you SUM() statements, like

Grand Total 2 =
var _calcSum = CALCULATE(SUM('Reference December AUM'[MKT_VALUE_USD]))
return 
if(_calcSum <0,BLANK(),_calcSum )

by the way, why do you use CLNTME in the statement?