Forum Discussion
Relationship between two different visuals (inside the same page).
Hi all; Need help. Currently, the visuals below is showing Sum of Inventories filtered by Mth End Close (Month End Close) & Corporate BU (Business Units). Mth End Close: months eg; Jul2023, Aug202...
Hi
I applied this formulae:
MthEndClose_Filter = if(isfiltered(MasterData_Eval[Mth End Close])&&selectedvalue(MasterData_Eval[Mth End Close])="ALL",Blank(),sum(MasterData_Eval[Inv ($ USD)]))
But then, if the user does not filter out the column [Mth End Close] - and this shows "ALL" as per the printscreen below, the formulae seems unable to work. I still get summation of all the inventories across all the months.
There is no blank inside the visual!
this is after putting in the measure inside the filter.