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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
JChouris
Helper I
Helper I

Time Study

I am very new to Power BI and a bit stuck on this one. I am doing a time study and need to multiply the skill and effort of each Procedure by the amount of seconds it takes, I need an individual total score for each step, then a grand totlat of the Skill and Effort Fields. I keep getting these crazy high numbers because it is using the total seconds and total skill/effort. Any help would be greatly appreciated. Thank you.

 

JChouris_0-1654532944881.png

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

@JChouris 

Try it like this.

Total Score = SUMX ( YourTable, YourTable[Seconds] * YourTable[Skill] )

 

View solution in original post

3 REPLIES 3
scottsk91
New Member

My cousin's brother wants to study abroad just because of this I shared this post with my brother. He asked me why are you send this to me, I said brother you just read it once you get good information from here. When I close this page I got this https://www.biologysap.com/ site details. I already read somewhere about this site. This one site is almost every student uses it just because of this quality.

jdbuchanan71
Super User
Super User

@JChouris 

Try it like this.

Total Score = SUMX ( YourTable, YourTable[Seconds] * YourTable[Skill] )

 

Worked like a charm. Thank you for you assistance.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.