Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |