Display information from multiple table and a measure in a table visual

[ThiagoDuarte]

Hi,

I'm building a pretty simple measure to sum the values (hours) from a related table and put it on a table with info from a third table

Table A (coois_control_quality):

item_id, serial number

Table B (01. Base de custo):

item_id, serial number, rework hours

They are related through a concatenate(item_id,serial number) column in each table (1->*)

[there can be multiple lines for rework hours, but every item_id and serial are unique]

I need to create a table visual to display: id, serial number, rework hours, and some information from other tables

I Tried a measure with CALCULATE(SUM(REWORK HOURS)) but when I set the table visual it takes forever for it to load this measure. This happens when i try to display data from all the tables in the imagem. If i only use coois_control_quality (item_id and serial number) with the measure it works. But I do need information from every table

Could someone help me?

Thanks,

Thiago Duarte

[lbendlin]

Rethink your data model. Which of the tables do you consider to be dimensions, and which tables are fact tables?