Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cumulative Sum

Hi All, I'm new to Power BI and I'm tyring to fix a dashboard someone else set up. I need to get a running total or cumulative sum for the code below. TIA for your help.

 

Hires =
CALCULATE(
    COUNTA('Candidate Activity'[Linked people: Person ID]),
    'Candidate Activity'[Step] IN { "26: Client Hire" }

1 Reply

  • selimovd's avatar
    selimovd
    Most Valuable Professional

    Hello Anonymous ,

     

    I think you have to give more details.

    Does the measure work? What is the result? What should the result look like? Running total over a hierarchy or over time?  How does your data model look like? How do your tables look like?

     

    Without more information it's hard to help you.

     

    Best regards
    Denis