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.
Greg_Deckler
Community Champion
Community ChampionIt 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.
That was exactly what I needed, thank you