228
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!