Sum based on a condition

[johndolan2]

Hi fumbling and hoping for some help. The examples I have looked at have not helped. ...  In the table below I am trying to sum for the city, based on the component. So NYC total would be 10 and the Tulsa total would be 6. The overall cost of Service # A equals 16. I will be using a slicer to select the city. Service # equals a single product. Components are all part of that single product. 

Any help would be very much appreciated.  Thanks, John

SERVICE #	COST	COMPONENT	CITY
A	5	Z PART	NYC
A	1	A PART	TULSA
A	5	Z ADD ON	NYC
A	5	A ADD ON	TULSA

[Fowmy]

@johndolan2 

Can you also share the expected result as you have shared the data?

[johndolan2]

Absolutley - The result for NYC would be 10. And the result for Tulsa would be 6. I only need to be able to show these on a card. So on my report page if I selected NYC on my city slicer, my card visual for NYC would show the number 10. John

[Anonymous]

A simple Sum measure should do the needful.

SUM of Cost = SUM(#Cost)

If you use above measure in a card and then try to slice by city or service, you should get the desired result.

[johndolan2 · Accepted solution]

OHHHHHHH Thank you!!!!!