Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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,
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.
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,
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,
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
87 | |
71 | |
63 | |
60 |