Unfiltered column subtotal

[Anonymous]

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

[v-yingjl]

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

[Greg_Deckler]

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

Also, maybe MM3TR&R: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...

[camargos88]

Hi @Anonymous ,

You can try it using the function HASONEVALUE.

Did I answer your question? Mark my post as a solution!
Ricardo