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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

DAX Help with total sum in a calculation

Hi 

 

I'm making a table, where one of the KPI's i want to show needs to be the individual persons impact of the total amount. 

Ex. 

in the table below i need to as shown calcutale Person 1's Talk time minus the total talk time 

it's quite easy in excel, but have been giving me a hard time in Power BI. 

 
 BCDEF
3 CallsTalk timeATTWhat I need
4Person 1102200220Talk time person1 - Sum(Talk time All)
5Person 2152700180Talk time person2 - Sum(Talk time All)
6Person 3204100205Talk time person3 - Sum(Talk time All)

 

My final goal should be a like this: (SUM(D4:D6)/SUM(C4:C6))-(((SUM(D4:D6)-D4)+(C4*190))/SUM(C4:C6))

The idea is to see what the individual impact is of total ATT if talk time where 190 

 

Hope you can help 🙂 

1 REPLY 1
Fowmy
Super User
Super User

@Anonymous 

Try this measure

Time_ = 

VAR _CALLS = 
    CALCULATE(SUM('Table'[Calls]),ALL('Table'))
VAR _TALKTIME = 
    CALCULATE(SUM('Table'[Talk time]),ALL('Table'))    


RETURN

DIVIDE(
    _TALKTIME,
    _CALLS
)
-
DIVIDE(
    (_TALKTIME - MAX('Table'[Talk time])) + (MAX('Table'[Calls])*190),
    _CALLS
    )

 

Fowmy_0-1595949456286.png

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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