Total costs based on slicer and graph interactions

jackquelynguyen · ‎10-09-2023

I am currently working on a report where I have 3 different projects: Apartment Units, Clubhouse, and Exterior. Each project has an Option A, Option B, and Option C and there are individual project budgets. My relationhips and slicers are set up correctly. I was able to write different measures that correctly show me the correct individual project total costs based on their individual value selection but for some reason I can't add all the total selected values and to get a total cost of all 3 projects as well as the total budget. My problem is that the total costs measures will work if i select the same value throughout the slicers, but if i select different values, the total costs turns blank. The measures i have are:

Total Costs = [Apartment Units Selected Cost] + [Clubhouse Selected Cost] + [Exterior Selected Cost]

Selected Value = [Apartment Units Selected Value] + [Clubhouse Selected Value] + [Exterior Selected Value]

parry2k · ‎10-09-2023

@jackquelynguyen wow that is a lot of details and not going to spend time reading all of it, sorry. It will be easier if you paste some sample data, what your data model looks like, and what is the end goal, it will help to provide a solution.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.