Reply
JChouris
Helper I
Helper I
Partially syndicated - Outbound

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

Syndicated - Outbound

@JChouris 

Try it like this.

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

 

View solution in original post

3 REPLIES 3
scottsk91
New Member

Syndicated - Outbound

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

Syndicated - Outbound

@JChouris 

Try it like this.

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

 

Syndicated - Outbound

Worked like a charm. Thank you for you assistance.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)