Cumulative Sum with Duplicate Date

[marcio_fornari]

Hello, I have a problem to sum a Cumulative Measure. 

Maybe this is happening because there duplicate Dates? 

If don't have duplicate dates: It's OK

But, if have a "RAZAO SOCIAL" value in the table, some date is duplicate, it's ok, but the Cumulative sum It's not ok.

The Dax is: 

Acumulado Saldo = 
CALCULATE(
    [Saldo do Dia];
    FILTER(
        All(fDADOS); fDADOS[DATA VENCIMENTO] <= MAX(fDADOS[DATA VENCIMENTO])
    )
)

Can someone help me?

Thanks

[Anonymous]

Hi, I am facing a similar issue and the above solution has not worked for me. 
I have data on sales of around 1600 restaurants for the months January-May 2022. Whatever I have tried it just duplicates the selected months' value. I want to make a card that shows Year to date value so e.g if I select April from the slicer so I want the card to show the sum of sales values of that particular restaurant from January-April while excluding months after April. 

[v-lid-msft]

Hi @marcio_fornari ,

We can try to use the following measure to meet your requirement:

Acumulado Saldo = 
CALCULATE(
    [Saldo do Dia];
    FILTER(
        All(fDADOS); fDADOS[DATA VENCIMENTO] <= MAX(fDADOS[DATA VENCIMENTO]) && fDADOS[RAZÃO SOCIAL] <= MAX(fDADOS[RAZÃO SOCIAL])
    )
)

If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared？

Best regards,

[marcio_fornari]

Hello, @v-lid-msft  Thanks for all. It's Almost

The Expected Result is:

[v-lid-msft · Accepted solution]

Hi @marcio_fornari ,

Sorry for our mistake in the formula, we can use the following measure to meet your requirement:

Acumulado Saldo =
CALCULATE (
    [Saldo do Dia];
    FILTER (
        ALL ( fDADOS );
        fDADOS[DATA VENCIMENTO] < MAX ( fDADOS[DATA VENCIMENTO] )
            || (
                fDADOS[DATA VENCIMENTO] = MAX ( fDADOS[DATA VENCIMENTO] )
                    && fDADOS[RAZÃO SOCIAL] <= MAX ( fDADOS[RAZÃO SOCIAL] )
            )
    )
)

Best regards,

[marcio_fornari]

Hello @v-lid-msft 

Perfect! Thanks for All.

[amitchandak]

Your cumulative is for dates and does not include RAZAO SOCIAL, that is why you are getting that

Refer :https://community.powerbi.com/t5/Desktop/ALLEXCEPT-in-a-multitable-setup/td-p/403205

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin