Forum Discussion
Table Visualization doesn't work when Measure is added
I'm creating a visual that shows the Operator Name, his/her Operator Code, and the associated amount of scrap ($) associated with their work. I can get the Operator Name and Operator Code to match up, but when I add the measure, the measure shows the Total value all the way down. I recognize this as a relationship problem, but I have the Operator Code in both of the tables from which I'm pulling the data so I figured that would solve the relationship problem. The only other thing I can think of is that the measure somehow is messing up the relationship.
ProdData
| Item_No | Operator | Vertical | Top | Bottom | Model | Vertical Min Length | Vertical Max Length | F/B Min Length | F/B Max Length | T/B Min Length | T/B Max Length | Vertical IT/OT | Top IT/OT | Bottom IT/OT | Complete I-beam Count | Incomplete I-beam Count |
| 1 | Op-1 | 199.9982 | 99.9979 | 60.0011 | HP500 | 199.99 | 200.02 | 99.99 | 100.07 | 59.998 | 60.003 | IT | IT | IT | 1 | 0 |
| 21 | Op-1 | 200.0143 | 99.9879 | 59.9993 | HP500 | 199.99 | 200.02 | 99.99 | 100.07 | 59.998 | 60.003 | IT | OT | IT | 0 | 1 |
| 22 | Op-1 | 200.0034 | 100.0046 | 60.0027 | HP500 | 199.99 | 200.02 | 99.99 | 100.07 | 59.998 | 60.003 | IT | IT | IT | 1 | 0 |
| 23 | Op-1 | 200.0161 | 100.0034 | 59.9988 | HP500 | 199.99 | 200.02 | 99.99 | 100.07 | 59.998 | 60.003 | IT | IT | IT | 1 | 0 |
| 24 | Op-1 | 199.9845 | 99.9937 | 59.9988 | HP500 | 199.99 | 200.02 | 99.99 | 100.07 | 59.998 | 60.003 | OT | IT | IT | 0 | 1
|
Part Costs
| Model | Vertical Cost | Top Cost | Bottom Cost | I-Beam Cost |
| HP500 | $ 4.95 | $ 2.87 | $ 6.01 | $ 13.83 |
Operators
| Operator Code | Operator Name | Model |
| Op-1 | Anderson | HP500 |
| Op-2 | Betts | HP500 |
| Op-3 | Carhart | HP500 |
| Op-4 | Dennison | HP500 |
| Op-5 | Evers | HP500 |
| Op-6 | Franks | HP500 |
| Op-7 | Guilfoyle | HP500 |
| Op-8 | Harris | HP500 |
| Op-9 | Ingalls | HP500 |
| Op-10 | Janison | HP500 |
| Op-11 | Kelty | HP500 |
| Op-12 | Lassiter | HP500 |
| Op-13 | Michaels | HP500 |
| Op-14 | Norris | HP500 |
| Op-15 | Oates | HP500 |
| Op-16 | Payton | HP500 |
| Op-17 | Quincy | HP500 |
| Op-18 | Rawlings | HP500 |
| Op-19 | Stevens | HP500 |
| Op-20 | Thomas | HP500 |
Measure
1 Reply
Hi Anonymous ,
Depending on the information you provide, you can modify the relationships between the tables like this to make the results display correctly.Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.