- Measures: Sales Amount, Sales YOY%
- Year: 2020, 2019
The visual displays 4 combinations, producing the cartesian products of all the measures and all the years selected. It would be useful to create a list of the combinations required, such as:
( [Sales Amount], 'Date'[Year]."2020" ),
( [Sales Amount], 'Date'[Year]."2019" ),
( [Sales Amount YOY%], 'Date'[Year]."2020" ),
The primary goal would be to obtain the desired result in a Matrix, but this would be also useful for Table and other visuals, including charts.
Comments
great
We need this feature.
Ideally this is an option for the visual itself, to specify yes/no by calculation group item if it is to be displayed, much as distinct series can be modified.
If you have groups of similar measures for say dollars and quantity e.g. MTD, YTD, Current, there is no way to combine MTD, YTD dollars and Current quantity in the same 3 column visual.
definitely need that
very useful!
This will go a long way to getting the most out of calculation groups.
This will make calculation group customizable and allow to control reporting what is required. Great idea.
A fantastic idea!
We run into this need constantly. Our workaround is to build models with complicated DAX queries on top of data models, which is inefficient and difficult to sustain. Please consider!