Forum Discussion
Unfiltered column subtotal
Hello everyone!
I'm trying to create an array that shows some measures filtered by a column, and then in the row subtotal I'd like to have the unfiltered total for those measures. It's possible?
As you can see, I have some selected measurements and a filtered column, but I'm struggling to find a way to display this information as if it were a simple "Participant A vs ALL Participants".
I've already created those measures using the ALL function, to get the values I want, but I still can't display those measurements in a visual that's easy to compare (as the screenshot above would be).
If it is not possible to filter the subtotals, is there a workaround for this?
Thank you
Lucas
3 Replies
- Greg_Deckler
Community Champion
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/547907Also, maybe MM3TR&R: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-Roll/td-p/411443
camargos88Hi Anonymous ,
You can try it using the function HASONEVALUE.
Did I answer your question? Mark my post as a solution!
Ricardo
v-yingjlCommunity Support
Hi Anonymous ,
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!
Best Regards,
Yingjie Li
