Forum Discussion
Multiply fields with a connection
Memorable Memberim not sure i understood but please try
Measure = CALCULATE( 'Table'[Tarifgruppe] * 'Table'[Arbeitszeitanteil]),ALLEXCEPT('Table','Table'[Tarifstufe]))
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
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.