245
When I combine measures and the content of a column in a matrix, I always get the visualization of all the combinations. For example:
- 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.
STATUS DETAILS
Needs Votes

Comments

M

great

M

We need this feature.

M

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.

M

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.

M

definitely need that

M

very useful!

M

This will go a long way to getting the most out of calculation groups.

M

This will make calculation group customizable and allow to control reporting what is required. Great idea.

M

A fantastic idea!

M

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!