Forum Discussion
Manipulation of Row Level Subtotal
I 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.
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.
I don't think PARENT is a DAX function. I tinkered a bit with EXPAND / COLLAPSE with no success.
you are right, I was thinking of COLLAPSE and COLLAPSEALL.
A while back Alberto had confirmed that this was a design gap
I don't know if VISUAL CALCULATION can handle it,
but if I assume for a minute that VISUAL CALCULATION can handle it, can it handle the DAX measure to handle pre or post evaluation.
If it is pre, I am interested but if post I am not. I want regular DAX/Visual Calcuation to restrict it from even evaluating on the Row Subtotal level.
