Forum Discussion
Condition ($ <>) in the expression
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.
Community ChampionTry changing your ALL to ALLEXCEPT, see documentation here:
https://msdn.microsoft.com/en-us/library/ee634795.aspx
I tried ALL EXCEPT but the displayed value is reset
- Greg_Deckler
You 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.