Having trouble filtering an aggregate measure.

[YYZENTHAL]

Hello!

I am having a terrible time trying to filter out "empty" values from a measure that I am using to sum one column from Table A and one column from Table B they share a unique identifier.  When I put the information in a table visual, the values show up correctly with the proper counts from Table A and the proper costs from Table B.  But the aggregation SHOWS the proper total costs per identifier, PLUS some other costs from Table B that do not have a value in Table A.  I cannot filter this out!  My Total cost shows $284,000, when it should be under $10k

Here are some screenshots and info:

Total Cost = SUM(Table A [Units Damaged] * SUM(Table B [Unit Cost]

Relationship is Table A Identifier = Table B Identifier 

Any help is appreicated, Thanks guys and gals 😃

David

[YYZENTHAL]

@Anonymous That did it thank you very much!

@mwegener Thank you for the response, no further action is required 😃

[mwegener]

Hi @YYZENTHAL ,

can you provide a screenshot of your model view?

[TomMartens · Accepted solution]

Hey @YYZENTHAL ,

try this measure:

Try this =
SUMX(
    'table A'
    , [Units Damaged] * RELATED('table B'[Unit Cost])
) 

Hopefully, this provides what you are looking for.

Regards,
Tom