Forum Discussion
Resolver ICumulative Sum with Duplicate Date
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
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,
6 Replies
- amitchandak
Super User
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 
v-lid-msftCommunity Support
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- v-lid-msft
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,
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.
