Help with measures in columns and rows

[Anonymous]

Hello all!!

I hope someone could help me with this doubt

I have a report and i want to show the measures in rows and columns in a matrix.

I created an auxiliar table, when have all the lables for the columns and created a measure, with switch to show in the rows the measure combined with the column.

I need to create this for five different measures,  I want to know if is possible to do in another way or I have to create all the measures for all the combination in the table.

I attach an example of the pbi.

https://drive.google.com/file/d/1exTbsOZ0d1pr7Ll7S4WM8uQO5DphW3q6/view?usp=sharing 

[lkalawski · Accepted solution]

Hi @Anonymous,

The way you do it is good, and unfortunately I'm afraid there is no other way to do it.

The only improvement that I can propose is to write one measure that will calculate data for months and filter the month with the Calculate and SelectedValue functions.

So e.g. in Amount Actual you will have something like this:

Amount Actual: = SWITCH (..., [Selection Measure] in {1,2, ..., 12}, Calculate ([Measure], Filter (All (Table), Month = SelectedValue (Month)))

 

_______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Thanks for your comments!!!

[amitchandak]

@Anonymous , not very clear to me.

You need to have a measure on the row for this. There is an option for that. Hope you have used that.

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

Can you elaborate your challenge