Multiply fields with a connection

[Milchmaa]

Hey there

I am very new to Power BI and tried so search a solution online but sadly did not find one (or I did not understand it maybe...).

I have two table. Left every "Tarifgruppe" has around 30 "Tarifgruppe". I want to multiply the value "Arbeitszeitanteil" with the corresponding field from the table left. Is this actually possible?

Many thanks already.

[eliasayyy]

im not sure i understood but please try 

Measure = CALCULATE( 'Table'[Tarifgruppe] * 'Table'[Arbeitszeitanteil]),ALLEXCEPT('Table','Table'[Tarifstufe]))

[Milchmaa]

I got an error with "Tarifgruppe" as there are various numbers. (it goes on with e.g. 20, 21...). 

For example Tarifstufe 1 and Tarifgruppe 12 but also Tarifstufe 1 with Tarifgruppe 20. 

Similar the right table. You know what I mean? 

[eliasayyy]

Im not sure im understanding i will ask questions if it not a problem

How many tables do you have 

If more than 1 , are they connected through a relationship? 

What is your expected results

[Milchmaa]

Really appreciate it.

3 tables which I connected through a relationship and the table which you see on the right (salary table) is a new one with no connection yet. 

Well let me try to explain it, the column Tarifgruppe is about the job. (12 could be carpenter, 13 could be chef) and column Tarifstufe is the level of experience (e.g. up to 20) and of course there are a lot of people on the list. On the right is the corresponding salary table.

Problem is I have a lot of people and possibilities which job and experience they have and now I want to calculate it for each job and experience. 

[eliasayyy]

Ok thank you for explaining can you send some sample data? And can a person id have different jobs?

[Milchmaa]

2 seconds ago

Tarifstufe	Tarifgruppe	difference between two dates
00	12	100
01	21	-150
02	22	200
03	23	-500
04	24	600

Sorry had some days off so just got back. And the table is quite bad but I hope it explains it. I want to multiply the difference in the table above with the corresponding salaray below (e.g. 100*207'513 or -150*55'761).

The Tables are a lot longer and a person can have different jobs.

below Tarifstufe, right Tarifgruppe	12	21
00	207'513	195'638
01	205'924	55'761
02	105'140	66'763
03	90'277	62'812
04	152'042	162'675