Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello,
I have a table that outputs like this:
I need to sum the "2018 Added Awards" column, based on the date 2018.
400+732 = 1132
This SUM is based on the "ProgID A" column, and ProgID A is controlled by a slicer. As soon as I remove ProgID A, I get the below result. I need to add 6 FOREACH ProgID A. Isn't there a way to do this? These are all measures.
Thanks,
Ashley
Solved! Go to Solution.
I'm not completely certain but this looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
I'm not completely certain but this looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Hi @Greg_Deckler,
This is a perfect solution, I had no issues implementing it into my project. Now, I look forward to diving in to it until I can understand how it works 🙂
Your screenshots were also helpful, they matched mine so I knew we were on the right track.
Cheers,
Ashley
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.