Forum Discussion
Helper IVCustom Total in Matrix
NJ81858 Right, so as described in those articles, I generally get the measure correct for an individual row. Then, create a new measure that uses that measure for individual rows but performs a SUMMARIZE or GROUPBY for subtotal rows and grand total rows. You can use ISINSCOPE or HASONEVALUE to identify where you are in the hierarchy.
Helper IVThis is what I have built out for a potential weighted average, but it isn't quite correct, as it just reflects every value, rather than being an average of the value. I also am having trouble getting it to show up as a row subtotal.
Community ChampionNJ81858 Right, so as described in those articles, I generally get the measure correct for an individual row. Then, create a new measure that uses that measure for individual rows but performs a SUMMARIZE or GROUPBY for subtotal rows and grand total rows. You can use ISINSCOPE or HASONEVALUE to identify where you are in the hierarchy.