cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CarDat
Frequent Visitor

Calculating Value taking data from different tables on condition

I have data from two tables that I want to mix in a matrix column, it only takes information from one table per row, a central table with a condition decides which table to take the data from (Picture Below)

 

 

I have three tables that are used to calculate the hourly sale rate of an employee.

 

Table 1 : Fixed Rate

This table contains the employee  and a fixed hourly sale rate

 

Table 2: Hourly rate per package

The hours of this employee are sold in packages and each package has an amount of hours and it can have a different rate per package

 

Table 3: Central Table

This tables contains the employee and which kind of hourly rate to apply

 

Table 4 : Employee Table ( Contains only employee data)

 

I have calculated two measures in order to calculate the average hourly sale rate, one for table 1 and one for table 2 . I want to use a measure that takes data from the calculated measure for table 1 when the employee belongs to the fixed hourly rate table, and from  measure 2 when the employee belongs to the hours sold in packages ( table 2).

 

CarDat_0-1634771919512.png

 

 

Is it possible to achieve something like this?

 

Thank you

1 REPLY 1
v-cazheng-msft
Community Support
Community Support

Hi @CarDat 

 

I roughly get your point. Is it convenit for you to provide some sample data so we can do research based on them to help you find the solution? Thanks in advance!

 

Best Regards,

Community Support Team _Caiyun Zheng

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!