Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to Solution.
@johndolan2
Can you also share the expected result as you have shared the data?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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!!!!!
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |