Forum Discussion
Community ChampionManipulation of Row Level Subtotal
Super Userthe simplistic answer would be HASONEVALUE but that can backfire badly if a parent level only has a single child.
Community ChampionI genuinely feel this is a problem that appears simpler than what it is. To gauge the full complexity, you need to give this a try.
- lbendlin
Oh, I have tried, and failed, a couple of times. I am fully aware of the complexities. In fact this is very much along the lines of the issue with field parameters. You cannot programmatically probe in which order a report user has added field parameter values to a visual.
Potentially visual calculations via PARENT could be an option.
- AlexisOlson
I don't think PARENT is a DAX function. I tinkered a bit with EXPAND / COLLAPSE with no success.
- lbendlin
you are right, I was thinking of COLLAPSE and COLLAPSEALL.
A while back Alberto had confirmed that this was a design gap
