Need help with a DAX measure issue, that doesn't filter correctly.

[MacJasem]

hi Guys/Girls

I've got a measure [FilteredTotal] & [Total], and i'd like to create a measure that returns the value from [Total] when the filter is active on the page, or else if filte is not active return the value for [FilteredTotal]. 

ConditionalTotal =

IF (

    ISFILTERED(ChartOfAccounts[Name]),

    [Total],

    [FilteredTotal]

)
but this doesn't really work, because the value for [Total] still shows when no filter is chosen. 

what might be the problem? please ask if you need more info to answer/help

[Anonymous]

Hi @MacJasem,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[some_bih]

Hi @MacJasem you put filter on account Finance[Account_No] > 1000, this cause this unexpected calculation. Is this what you want?

On visual you can exclude subtotal for rows / columns.

[MacJasem]

yes this is intended because this is the only difference between Total and FilteredTotal measures, so i want to switch between those two measures depending on the filter choice

[some_bih]

Hi @MacJasem it must be something about one of your measure definition.

I guess you want to controll some subtotal/total in table /matrix. If yes, when you need to workout your measure. Hope this help kudos appreciated.

[MacJasem]

Thanks @some_bih for the feedback

the two measures that i want to switch between are:

Total =  SUM ( Finance[Sum_Amount] )

and

FilteredTotal = SUMX(FILTER(Finance, Finance[Account_No] > 1000), Finance[Sum_Amount])

I really can't seem to figure out what the issue is. 

I have a clustered column chart as the visual where i'd want the measure to switch between the result of the above two measures.