Multiply fields with a connection

Question

Hey there&nbsp;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.&nbsp;

eliasayyy · Answer

im not sure i understood but please try&nbsp;Measure = CALCULATE( 'Table'[Tarifgruppe] * 'Table'[Arbeitszeitanteil]),ALLEXCEPT('Table','Table'[Tarifstufe]))

milchmaa · Answer

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 · Answer

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 · Answer

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.&nbsp;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.&nbsp;

eliasayyy · Answer

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

Forum Discussion

Multiply fields with a connection

6 Replies

Related content

multiplier

Count Values multiplied by a measure

Connection failed using a Folder connection in a pipeline

IF and Multiply

connection to dataflows