Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

ALLEXEPT function doesn't work with date slicer

AAA = CALCULATE(SUMX(Impaye,Impaye[Nombre Impaye]), ALLEXCEPT(Impaye,Impaye[IdPretAide]))

Anonymous
3 years ago
Hi Anonymous ,

Is [Nombre Imapye] a measure or a column?

If it's a measure, please try

AAA = SUMX ( FILTER ( ALL ( Impaye ), [IdPretAide] = MAX ( Impaye[IdPretAide] ) ), [Nombre Impaye] )

If it's a column, please try

AAA = SUMX ( FILTER ( ALL ( Impaye ), [IdPretAide] = MAX ( Impaye[IdPretAide] ) ), SUM ( Impaye[Nombre Impaye] ) )

If you still have doubts, provide some dummy sample data, along with the desired results. If [Nombre Impaye] is a measure, please provide a description of this formula. Remember to protect data privacy.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icon for Solution Sage rank

Solution Sage

3 years ago

Can you add a

ALLSELECTED() to

RESULT = Calculate(A,ALLEXCEPT(...),ALLSELECTED())

Anonymous
Not applicable
3 years ago
doesn't work like this :
AA =

VAR EndDate = MAX( Impaye[Code Date] )

VAR StartDate = MIN( Impaye[Code Date] )

VAR A = CALCULATE(SUMX(Impaye,Impaye[Nombre Impaye]), 'Impaye'[Code Date] >= StartDate && 'Impaye'[Code Date] <= EndDate)

VAR Result = CALCULATE(A,ALLEXCEPT(Impaye,Impaye[IdPretAide]),ALLSELECTED())

RETURN Result
- andhiii079845
  Solution Sage
  3 years ago
  Perhaps someone else knows a good solution. I would try to use summerize to have the sum per idpretaide and do than the further operations.