Sum for each Different Job Number

[MaryGraceP]

I created the "POUNDS OUT" measure (see code below) which I want to equal the sum of the column Perfection for each Job when WIP/ING/PKG is equal to "Line". 

The way I have the measure set up, it will display properly when WIP/ING/PKG is included in the table but when I take it out it sums all of the Perfection column. AKA it equals 773k instead of retaining its value of 70K. 

Do I need to create the measure differently? Add something? Thanks for the help!

POUNDS OUT =

CALCULATE(

    SUM('Yield Table'[Perfection]),

    FILTER(

        'Yield Table',

        contains ( 'Yield Table', 'Yield Table'[WIP/ING/PKG],"Line")

    ))

[MasonMA]

Thie simpler way is using KEEPFILTERS to wrap over the filter context. 

Measure2 =

CALCULATE(

    SUM('Table'[Perfection]),

    KEEPFILTERS('Table'[WIP/ING/PKG] = "Line")

    )

[ajaybabuinturi · Accepted solution]

Hi @MaryGraceP,

COuld you please try with below DAX

POUNDS OUT =
VAR CurrentJob = SELECTEDVALUE('Yield Table'[job])
RETURN
CALCULATE(
SUM('Yield Table'[Perfection]),
  FILTER(ALL('Yield Table'),
    'Yield Table'[job] = CurrentJob && 'Yield Table'[WIP/ING/PKG] = "Line"
        )
)

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.