Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello all
In the picture below, i have 4 columns that display the 4 quarters of the year.
Now, i need Q2 to be the Sum of Q1 and Q2. Q3 = Q1+Q2+Q3 and same for Q4.
So Q4 would be 2'361'693.
Can i do that with a measure?
Any ideas?
Best regards
Solved! Go to Solution.
@Anonymous
Please change the formula to this one:
Cumulative_Actual = CALCULATE ( SUM ( Sheet1[Value] ), FILTER ( ALLEXCEPT( Sheet1, Sheet1[frango]), Sheet1[Quarter] <= MAX ( Sheet1[Quarter] ) ) )
Aslo you can see the formula in this workspace
@Anonymous
Can you try the following:
Cumulative_Actual = CALCULATE ( SUM ( Sheet1[Values] ), FILTER( ALL (Sheet1 ), Sheet1[Quarter] <= MAX( Sheet1[Quarter] )) )
Thanks for the quick response.
I did not get it to work.
I think further infos are needed.
Matrix looks like:
With the fields:
Measure regarding your answer:
Cumulative_Actual = CALCULATE ( SUM(Alles[Media Net exkl. WZ]) + SUM(Alles[Posting Net]); FILTER(ALL (Alles[Quartal]); Alles[Quartal] <= MAX(Alles[Quartal])) )
"Alles" is the table. Its only one table with all the infos in there.
I inserted tte result measure as column instead of "Quartal".
What are my wrong thoughts?
Remove Quartal which is right after All.
New formual attached:
Cumulative_Actual = CALCULATE ( SUM(Alles[Media Net exkl. WZ]) + SUM(Alles[Posting Net]); FILTER(ALL (Alles); Alles[Quartal] <= MAX(Alles[Quartal])) )
Already edited it that way (Because you edited your first answer)
Its missing the "Frango" Column, it should be considered somehow.
The result i get now is the total of all frangos.
And also, i need 4 columns, not 1 that is the total.
@Anonymous
Have you put frango as rows, Quarters as Columns and values will be the new measure?
On a matrix and not on a single table
Yes i do.
Expected for first frango:
Not really...
But i will try to create a file with dummy data for you.
That should work just as our original file.
@Anonymous
Please change the formula to this one:
Cumulative_Actual = CALCULATE ( SUM ( Sheet1[Value] ), FILTER ( ALLEXCEPT( Sheet1, Sheet1[frango]), Sheet1[Quarter] <= MAX ( Sheet1[Quarter] ) ) )
Aslo you can see the formula in this workspace
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |