Forum Discussion

Victor_Oliveira's avatar
Victor_Oliveira
New Member
2 years ago
Solved

Filtering accumulated measures with dates

Hi! I´m having trouble with the measure below   CALCULATE( DISTINCTCOUNT('Base Geral'[Codigo]), 'Base Geral'[Status] = "Concluído", 'Base Geral'[IO] = -1, FILTER( ALL(...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Victor_Oliveira 

     

    Your measure should be correct, and at least in my simple test, it worked.
    Make sure your date slicer is using 'calendario'[Date], not 'Base Geral'[Date].

     

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

     

     

marcelsmaglhaes's avatar
marcelsmaglhaes
Icon for Super User rankSuper User
2 years ago

Hey Victor_Oliveira 

Maybe you can use ALLSELECTED instead of ALL to keep date filters. This theoretically allows the accumulation while respecting date filters from slicers.

Acumulado =
CALCULATE(
DISTINCTCOUNT('Base Geral'[Codigo]),
'Base Geral'[Status] = "Concluído",
'Base Geral'[IO] = -1,
FILTER(
ALLSELECTED('calendario'[Date]),
'calendario'[Date] <= MAX('calendario'[Date])
)
)