Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Rethink your data model. Which of the tables do you consider to be dimensions, and which tables are fact tables?