Matrix Table

[Anonymous]

Hi All, I have data in the following format:

Time	Country	Value
3M	AU	10
6M	AU	20
YTD	AU	30
3M	UK	50
6M	UK	60
YTD	UK	70
3M	US	90
6M	US	100
YTD	US	110

I need to show the data in the following format in the matrix visual:

Time	Value
AU
3M	10
6M	20
YTD	30
UK
3M	50
6M	60
YTD	70
US
3M	90
6M	100
YTD	110

Please help in letting me know what DAX measure should I use to create this Matrix values.

[JorgePinho · Accepted solution]

In the matrix visual:

Rows box: Country, Time (in this order)

Values box: Value