Calculate the KPI share of the category weighted by the KPI

[Ersin_K]

Hi everyone,
I need help with a question that I unfortunately can't solve with my DAX knowledge and with a lot of searching. Maybe one of you can help me.

In Excel I solve the problem as follows:

In PowerBI i habe one Table with the Data

The KPI1 "Call Handling Time ACT" was Calclulate als a Measure:

CHT =

DIVIDE(
sumx(
filter('Data_vw_Kuko_Tagesdaten',
[Intern/Extern/Gesamt]IN{"Intern","Extern"}&&
[Kennzahl]="Workload"&&
[FC-Stand]="Ist")
,
'Data_vw_Kuko_Tagesdaten'[Wert])
,
sumx(
filter('Data_vw_Kuko_Tagesdaten',
[Intern/Extern/Gesamt]IN{"Intern","Extern"}&&
[Kennzahl]="Menge"&&
[FC-Stand]="Ist"),
'Data_vw_Kuko_Tagesdaten'[Wert])
)
*60

The KPI2 "Calls ACT" was Calclulate als a Measure to:

Calls ACT =

CALCULATE(
SUM(Data_vw_Kuko_Tagesdaten[Wert]),
Data_vw_Kuko_Tagesdaten[FC-Stand]IN { "Ist"},
Data_vw_Kuko_Tagesdaten[Kennzahl]="Menge",
Data_vw_Kuko_Tagesdaten[Eingang/Angenommen/Aufleger]="angenommen"
)

I would like to calculate the CHT share of the category ("Themengruppe") weighted by the calls total and display the result in a matrix graph like the 3Table in the Pic.

Unfortunately, I can't get this weighting with the two measures displayed in a matrix table. Maybe you can help me.

Thank you in advance

Ersin