Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am pretty desperated. Can someone please tell me how I get the accumulated sum of the columns "PercentageOfTotal" here? (see picture) I tried everything 6hours but nothing is working. Also tried quick measure calculated sum, but it did just gave me the same column - no runnuing sum.
I am even thinking that something with Power BI is not working.
Hi @ChristianPower , here is pic
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Here is something close
running total in Date =
CALCULATE(
[Sales Amount],
FILTER(
ALLSELECTED('Calendar'[Date]),
ISONORAFTER('Calendar'[Date], MAX('Calendar'[Date]), DESC)
)
)
Replace [Sales Amount] by your "Percentage of totalt" and "'Calendar'[Date]" by your Rank column
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi, you have missed out FILTER function.
Try write something like:
CALCULATE(SUM(Spend Tail Analysis[PercentageOfTotal],
FILTER(ALL(Spend Tail Analysis), Spend Tail Analysis[Rang] <= MAX(Spend Tail Analysis[Rang]))
If this solution works for you, please mark it as solution to allow other searching members easily find solutions.
Hi @ChristianPower , Try this
RT =
VAR _getRang =
MAX ( myTable[Rang] )
VAR _calc =
CALCULATE (
SUM ( myTable[PofTotal col] ),
FILTER ( ALL ( myTable ), myTable[Rang] <= _getRang )
)
RETURN
_calc
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |