Table Visualization doesn't work when Measure is added

[Anonymous]

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

I-Beam Scrap Cost =

SUMX (

    VALUES ( ProdData[Model] ),

    VAR OperatorIncompleteCount =

        CALCULATE (

            SUM ( 'ProdData'[Incomplete I-beam Count] ),

            'ProdData'[Incomplete I-beam Count] = 1,

            'ProdData'[Model] = EARLIER ( ProdData[Model] )

        )

    RETURN

        OperatorIncompleteCount

            * SUMX (

                RELATEDTABLE('Part Costs'),

                'Part Costs'[I-Beam Cost]

            )

)

[Anonymous]

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.