Forum Discussion
Condition ($ <>) in the expression
I have a measure and need to apply it a filter condition when the User filter a month the value of the measure need to be maintained even if the value used in the measure has no relationship with the...
It sounds like you need an ALL or ALLEXCEPT clause in your SUM calculation. Generally, you do this by wrapping the SUM in a CALCULATE like:
CALCULATE(SUM(VI_ReceitaPrevista),ALL(table))
Basically, the ALL and ALLEXCEPT clauses create an context for the SUM that is independent of other contextual filters that may be applied, like from slicers. Can't really get too specific without sample data.
I tried ALL EXCEPT but the displayed value is reset
Greg_Deckler
Community Champion
Community ChampionYou may have to add some columns to your ALLEXCEPT clause. It is really difficult to be specific without sample data and your expected output. ALLEXCEPT removes all context filters except for the ones that you specify in the ALLEXCEPT function.