Cumulative sum in the Scatter Map Visual

[Lucasecg]

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 but haven't been able to solve it yet.

I am developing a map where the points sum up a number (sales made). One of the most important filters for the project is to filter by month and day. However, when selecting 2 different months, the visual shows 2 overlapping points with the sales for each month (separately). I need the visual to show the cumulative sum of the selected months, meaning it should display a single total at each point.

I have attached images to facilitate understanding.

Thank you!

[Anonymous · Accepted solution]

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.