Forum Discussion

Kolumam's avatar
Kolumam
Icon for Post Prodigy rankPost Prodigy
8 years ago

Page level filter is ignored in Cumulative Measure

Hi All,   I have a field called Stage Name which I am using it as a page level filter to filter a measure.   My formula is like this: Cumulative Size Won = CALCULATE(SUM(Project[Size (MWp)]), FI...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

That is correct, I have highlighted the issue:

 

Cumulative Size Won = CALCULATE(SUM(Project[Size (MWp)]),
FILTER(ALLEXCEPT(Project,Countries[Country],
'Project Phases'[Phase]),
AND(Project[Project Phase (with hold On Hold)]<>"Abandoned",
AND(Project[Phase]<>"LOI",Project[PPA Date] <= MAX(Dates[Last day of month])))))

Probably should be:

 

Cumulative Size Won = CALCULATE(SUM(Project[Size (MWp)]),
FILTER(ALLEXCEPT(Project,Countries[Country],
'Project Phases'[Phase],'Project Phases'[Stage Name]),
AND(Project[Project Phase (with hold On Hold)]<>"Abandoned",
AND(Project[Phase]<>"LOI",Project[PPA Date] <= MAX(Dates[Last day of month])))))