DAX Help with total sum in a calculation

Anonymous — Tue, 28 Jul 2020 08:44:21 GMT

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.

	B	C	D	E	F
3		Calls	Talk time	ATT	What I need
4	Person 1	10	2200	220	Talk time person1 - Sum(Talk time All)
5	Person 2	15	2700	180	Talk time person2 - Sum(Talk time All)
6	Person 3	20	4100	205	Talk 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 🙂

Re: DAX Help with total sum in a calculation

Fowmy — Tue, 28 Jul 2020 15:17:58 GMT

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 )

________________________

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

topic Re: DAX Help with total sum in a calculation in DAX Commands and Tips

DAX Help with total sum in a calculation

Re: DAX Help with total sum in a calculation