Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jafdias
Frequent Visitor

DAX With Percentage Total accumulated

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.

 

DAX.png

 

I Really apreciate if someone could help me with this case.

Thanks.

JDias

1 ACCEPTED SOLUTION
Phil_Seamark
Employee
Employee

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

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

Hi jafdias,

 

Could you please share some dummy data for further analysis?

 

Regards,

Jimmy Tao

Ashish_Mathur
Super User
Super User

Hi,

 

Share the link from where i can download your PBI file.  Ensure that you have the volume measure in your visual.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Phil_Seamark
Employee
Employee

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

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hello Phill, thank you for your answer.

 

Your solution workly perfectly in my case.

 

Thank you so much for your help.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.