Report Portal

Switching Subtotals On and Off Dynamically Using DAX in PowerPivot

Subtotals on or off for a field - They're the options that you get. That's probably great for a lot of situations, but I would put money on the majority of readers of this post having had a situation where they've asked "where's the option to not display a subtotal when there's only one record being shown?". Frustrating isn't it? You end up with a load of subtotals simply repeating the same value as it's own one subset member because one of your other report elements has a subset of data that does need subtotalling. You can, of course, toggle the show and hide for each member, but wouldn't it be better if it was dynamic?

Read more...

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.