Forum Discussion
NourJ
Helper III
Helper IIICalculate Cumulative by applying multiple factors
Hi Community, I want to calculate cumulative by applying multiple factors not only date. the following measure works well when I filter by date but when I filter by location or cause it is not. ...
Daniel29195
Community Champion
Community ChampionHello NourJ
try this :
CALCULATE (
cumulative_new_arrival[New_Arrivals],
ALLEXCEPT(
'cumulative_new_arrival',
cumulative_new_arrival[District],
cumulative_new_arrival[Cause of Displacement]
),
'cumulative_new_arrival'[Week of the Year] <= Max ('cumulative_new_arrival'[Week of the Year])
))
if it doesn work :
try this version :
CALCULATE (
cumulative_new_arrival[New_Arrivals],
removefilters ( 'cumulative_new_arrival'[Week of the Year] )
),
'cumulative_new_arrival'[Week of the Year] <= Max ('cumulative_new_arrival'[Week of the Year])
))
let me know if it works for you .
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button 🫡👍
NourJHelper III
Helper IIII tried both first works for date but not for other filters and the second one works when I filter by location but not by date