Subtraction of Below value ( Droped Calls )

[hello_]

Hello Expertise,
I am facing a problem with this measure where I want the dropped call of every terminating client by destination and Originating Client 
I have call records data where every originating client has some region and on those regions, there are multiple terminating clients these Terminating client receives calls except successful calls other calls are then passed on to other terminating clients

Example: here is an originating client named Tom he transferred  500 calls to Timtim terminating clients of the India region, Successful Calls are the calls Teremanating clients are accepting here Timtin Terminating client has not accepted any calls then he should drop those 500 calls to the next terminating client but as you can see in the table he dropped only 300 calls, now the total calls for Nyer terminating is 300, I this scenario the measure should return 200 as 200 calls are Killed.
Here originating client, Terminating client and region are columns, and others are measures

Please see the sample Data -

originating client	Region	Terminating client	Total_calls	Successful calls	Diff	Killed_calls
Tom	India	Timtim	500		500	200
Tom	India	Nyer	300	50	250	30
Tom	India	MSD	220	2	218	38
Tom	India	WXT	180		180
Tom	Myanmar	TeaMZ	1200	500	700
Tom	Philippines	DX	150	20	130	90
Tom	Philippines	Timtim	40		40	30
Tom	Philippines	Nyer	10	2	8
Roro	Myanmar	MSD	1658	1200	458	108
Roro	Myanmar	WXT	350	25	325
Roro	India	DX	560		560

Please lend me your Knowledge and help with the mentioned query 
Thank you in advance

[Anonymous]

Hi @hello_ ,

Based on your problems, here are my answers.

In Power BI, measure and calculate columns deal with relationships between columns and are not directly associated with other rows. The data you provided seems to be a row to row relationship, I can get Diff's measure but I can't realize the other measures.

Column = 'Table'[Total_calls] - 'Table'[Successful calls]

You can read the official documentation for measure and calculate columns: Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn and Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hello_]

Hello @Anonymous 
Thank you for the reply,
but I want the measure for killed calls and the killed call in the table is for output reference

[Anonymous]

Hi @hello_ ,

I have understood you that you want to build a Measure for Killed_calls, but as I said in my reply above, it looks as if there is no logic to get Killed_calls as a Measure, and it looks like it's a row to row relationship, where in Power BI Measure and Calculate Column are column-to-column relationships, so it's more difficult to try to implement.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.