Create Table where one of the columns values are the results of diferent measures

[antonioaceituno]

Hi!

I have created several measures in one table. Each measure is related to one month. (Ratio month 1, Ratio Month 2...etc)

Now I need to create another table, where all this Ratio measures (order by month ascending) are located in the same column, because I want to plot them in an X axis, and it would have to be segmented by other variables as well, in the same resulting table.

How could I do it?

Thank you so much in advance

[antonioaceituno]

@Sujit_Thakur , I need to use a Measure in X axis, so that each division in that axis is a diferent measure.
I would calculate 12 measures (one per month), and represent those calculations over the X axis.

I just can represent those measures as Values in the chart, but not along the X axis.

Thanks!

[v-deddai1-msft · Accepted solution]

Hi @antonioaceituno ,

We can't use measure in x-axis, so we need convert it to column. Just verify how your context works, as when you convert a measure - that is supposed to work in a filter context - to a column - which has a row context - your measure will calculate in a different way. You can use ROW and UNION function like below to convert your measure to column.

Table  = UNION(ROW("month",1,"measure",[measure1]),ROW("month",2,"measure",[measure2]),ROW("month",3,"measure",[measure3]))

Then you can use measure column in Table to x-axis. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@antonioaceituno , measure to column conversion would be static. No impact of the slicer.

See of show on the row of Matrix can help

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

[Sujit_Thakur]

@antonioaceituno 

@Please elaborate and tag and reply so that I can hel