Creating New Table using values in other tables in PowerBI

[moumitadeb]

I have 2 tables. Table1 has static data as below:

KPI	Target
A	>90% within 30 Business Days
B	>90% within 60 Business Days
C	>90% within 30 Business Days
D	>90% within 60 Business Days
E	>90% within 30 Business Days
F	>90% within 60 Business Days

Table 2 has all the columns, calculated measures. This is the main table. There are measures (count & SLA%) for each KPI values.I need to combine this 2 tables & the output should be as below, based on the matching KPI values:

KPI	Target	SLA	Count
A	>90% within 30 Business Days	91%	11
B	>90% within 60 Business Days	100%	1
C	>90% within 30 Business Days	100%	7
D	>90% within 60 Business Days	21%	19
E	>90% within 30 Business Days	100%	3
F	>90% within 60 Business Days	100%	1

Any help is appreciated!

[manvishah17]

Hi @moumitadeb , can you please sample data for table 2 ?

[moumitadeb]

I have posted the table 2 data . Any ideas is appreciated !

[_AAndrade]

Hi @moumitadeb,

Could you share the data of table 2?

[moumitadeb]

I have posted the table 2 data . Any ideas is appreciated !