Forum Discussion
Temporary custom tables? (Plot grand total)
Hi Since PBI does not offer the option to plot a grand total when plotting a measure by groups, I am creating custom tables to achieve the result: 1. Create custom summary table by group (Table ...
Hi
I might be misunderstanding your request but are you trying to plot a straight line for the grand total? If not an example screenshot of what you are trying to achieve would be helpful.
If it is a straight line then this is easy to achieve by creating a new measure that removes any filters applied to your existing measure.
Eg
Grand total measure = calculate( [existing measure], all(table1), all(table))
I might be misunderstanding your request but are you trying to plot a straight line for the grand total? If not an example screenshot of what you are trying to achieve would be helpful.
If it is a straight line then this is easy to achieve by creating a new measure that removes any filters applied to your existing measure.
Eg
Grand total measure = calculate( [existing measure], all(table1), all(table))