Need help with Grouping Different Measures under different custom column headers

[as1195]

Hi,

There is a requirement from business to group different measures under different custom columns in the Matrix .Please help me to achieve this.Currently all of the measures are individually dragged into value field having rows as geography and Brand.

expected matrix:
Rows:Geography & Brand
Column : Value Growth,Volume Growth,V Share,Price Growth
values: A1,A2,B1,B2,C1,D1,D2,D3,D4

Any help would be much appreciated 🙂
Thanks

[ValtteriN · Accepted solution]

Hi,

It isn't possible to have a different measure for different columns in a matrix visual, but what you can do is to modify your data so that column1 + column2 + column3 data is in one category column then create a switch measure which will select different results/calculation logics based on "column"

e.g.

Here depending on the column my measure returns 1,2 or 3. You can replace these values with measures to achieve your goal.

Measure 20 =

var _s = MAX('Table (8)'[Column1]) return

SWITCH(TRUE(),

        _s="X",1,

        _s="Y",2,

        _s="Z",3) //replace 1,3 and 3 with your measures/values

Note that the matrix is showing blanks if the selected column doesn't have the correct geography. 

So to summarize: user powerquery or other methods to get your data into a suitable format (pivot your data) and then create a switch + true measure structure to create the calculation logic.



I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/