Forum Discussion

Lucasecg's avatar
Lucasecg
New Member
2 years ago
Solved

Cumulative sum in the Scatter Map Visual

Hello community! I am a beginner in Power BI trying to work on some projects on my own. I ask for a little patience and also apologize if my question is very basic. I've tried looking up videos ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Lucasecg ,

     

    Filters are meant to filter data and don't have this ability to aggregate data, so you may need to create a metric or calculated column implementation. For example, the following expression:

    Cumulative Sales = 
CALCULATE (
    SUM ( YourTableName[SalesColumn] ),
    FILTER (
        ALLSELECTED ( YourTableName[DateColumn] ),
        YourTableName[DateColumn] <= MAX ( YourTableName[DateColumn] )
    )
)

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Lucasecg ,

 

Filters are meant to filter data and don't have this ability to aggregate data, so you may need to create a metric or calculated column implementation. For example, the following expression:

Cumulative Sales = 
CALCULATE (
    SUM ( YourTableName[SalesColumn] ),
    FILTER (
        ALLSELECTED ( YourTableName[DateColumn] ),
        YourTableName[DateColumn] <= MAX ( YourTableName[DateColumn] )
    )
)

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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