Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Running Total to Ignore Specific Filter

Okay. So I've made a lot of progress on a Running Total measure (and again much thanks to these forums), but I have one additional question. Bear with me as I'm still learning about contexts and filt...
  • jahida's avatar
    jahida
    10 years ago

    Can you add a clause to the CALCULATE function with ALL(Table[Column]) with whatever column the slicer is based on?

jahida's avatar
jahida
Impactful Individual
10 years ago

Can you add a clause to the CALCULATE function with ALL(Table[Column]) with whatever column the slicer is based on?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

jahida Thanks for the suggestion, and initially it wouldn't work. But I just modified the original to:

 

RunningGradTotal2 = CALCULATE(CALCULATE(DISTINCTCOUNT(DegreeConferred[StudentID]),FILTER(ALLSELECTED(DegreeConferred),DegreeConferred[TERM_END_DATE]<=MAX(TermInfo[TERM_END_DATE])),VALUES(CohortOriginal)),ALL(TermInfo[Semester]))

 

And now that's working. I wasn't aware that you could nest multiple CALCULATE() statements together, but it looks like that makes sense. It the equation ignores the Semester filter I have set at the Page level and still gives me my correct Running Total.

 

Thanks for the assist!

  • MWinter225's avatar
    MWinter225
    Advocate IV
    7 years ago

    Anonymous This helped me a lot thanks!