Measure that Calculate Total Net Sales if Check Contains Item

[Anonymous]

Hey guys,

I'm trying to create a DAX measure that calculates the Total Net Sales of all items on a check, if the check contains a certain Item.

Here's a couple dummy tables linked on ItemID. Basically I want to be able to Calculate the Total Net Sales of CheckIDs that contain ItemID 1 (which would be $7).

[Anonymous · Accepted solution]

Hi jeremy808,

Check care this image out.

Tell us if works for you.

[Anonymous]

This is what I needed! Thanks