Need calculation on Voice contacts with Agent names and Non Voice contacts with out Agent Names

[arun2001mjl]

Hello All,

I have 2 Tables in PowerBI.. Both are different files.

1st Table with Voice Data.

2nd Table with Non Voice data.

Now i need add "No of Calls handled" + "No of non-voice handled" agent wise.

I need the result as in E Column in PowerBI. I tried the measure but iam not able to spilt "No of non-voice handled" by agent wise.

Regards

Arun

[arun2001mjl]

Hi,

Iam getting this error when i use below Dax

Column:

Column =
LOOKUPVALUE (
    'Table 2'[No of Non-Voice Handled],
    'Table 2'[Delivery Location], Table1[Delivery Location],
    'Table 2'[Date], Table1[Date]
) + Table1[No of Calls Handled]

Measure:

Column = 
LOOKUPVALUE (
    'Table 2'[No of Non-Voice Handled],
    'Table 2'[Delivery Location], Table1[Delivery Location],
    'Table 2'[Date], Table1[Date]
) + Table1[No of Calls Handled]

Note: For no of Non Voice Contacts already i have calculation in PowerBI.

Email + chat + Web + Portal = Non Voice Contacts.

When i use above your dax measure, iam getting below error.

Please assist.

[v-luwang-msft]

Hi @arun2001mjl ，

Generally, this error occurs because the query returns more than one value, for example, A1 in columnA in table A matches columnA1 in table B and gets more than one value of columnA2 in table B. This should be checked for duplicate data.

Best Regards

Lucien

[v-luwang-msft · Accepted solution]

Hi @arun2001mjl ,

You need to create a new column by the below dax:

Column =
LOOKUPVALUE (
    'Table 2'[No of Non-Voice Handled],
    'Table 2'[Delivery Location], Table1[Delivery Location],
    'Table 2'[Date], Table1[Date]
) + Table1[No of Calls Handled]

And if you want to create measure ,try the below:

Column = 
LOOKUPVALUE (
    'Table 2'[No of Non-Voice Handled],
    'Table 2'[Delivery Location], Table1[Delivery Location],
    'Table 2'[Date], Table1[Date]
) + Table1[No of Calls Handled]

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[arun2001mjl]

I shared the output in text format.. Still no solution found.

[arun2001mjl]

Delivery Location is related with both the tables.

Voice Contacts	Table 1					Non Voice Contacts	Table 2
Agent Name	Delivery Location	Date	No of Calls Handled	I need result as followups		Delivery Location	Date	No of Non-Voice Handled
Agent 1	India	21-Dec	210	D3 + I3		India	21-Dec	88
Agent 2	India	21-Dec	313	D4 + I3		Australia	21-Dec	60
Agent 3	London	21-Dec	213	D5 + I5		London	21-Dec	90
Agent 4	India	21-Dec	435	D6 + I3		Japan	21-Dec	77
Agent 5	China	21-Dec	234	D7 + I7		China	21-Dec	66
Agent 1	London	21-Nov	322	D8 + I10		India	21-Nov	99
Agent 2	Australia	21-Nov	676	D9 + I9		Australia	21-Nov	54
Agent 3	China	21-Nov	645	D10 + I12		London	21-Nov	67
Agent 4	Japan	21-Nov	34	D11 + I11		Japan	21-Nov	87
Agent 5	London	21-Nov	653	D12 = I10		China	21-Nov	34

[Samarth_18]

Hi @arun2001mjl ,

Could you please share the data in the text format instead of screenshot?

Apart from that do you have any relationship between these two table?

BR,

Samarth

[arun2001mjl]

Please replace J with I.