Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Guys,
I'd Like to know if can i do a DAX calculation with a percentage accumulated like picture above in "Shipment" Column.
The First Line (CETUS) represents 33% of Total Sum of Volume.
The Second Line represents 23% (Apus) + 33% (Cetus) and the same function for other lines.
I Really apreciate if someone could help me with this case.
Thanks.
JDias
Solved! Go to Solution.
Hi @jafdias
You could try something along the lines of this calculated column. I have attached a PBIX file to this message with a working example.
Column = VAR Total = SUM('Table1'[Volume]) VAR RunningTotal = SUMX(FILTER('Table1','Table1'[Volume] >= EARLIER('Table1'[Volume])),'Table1'[Volume]) RETURN RunningTotal / Total
Hi,
Share the link from where i can download your PBI file. Ensure that you have the volume measure in your visual.
Hi @jafdias
You could try something along the lines of this calculated column. I have attached a PBIX file to this message with a working example.
Column = VAR Total = SUM('Table1'[Volume]) VAR RunningTotal = SUMX(FILTER('Table1','Table1'[Volume] >= EARLIER('Table1'[Volume])),'Table1'[Volume]) RETURN RunningTotal / Total
Hello Phill, thank you for your answer.
Your solution workly perfectly in my case.
Thank you so much for your help.
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |