Forum Discussion
Solved
Sum based on a condition
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 ...
OHHHHHHH Thank you!!!!!
johndolan2
Can you also share the expected result as you have shared the data?
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
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.
OHHHHHHH Thank you!!!!!