matrix with two sets of measures

[mikebi]

Hello,

I would like to create a matrix with two different measures for the columns like below.

The alternative is to create two matrixes but my users want a single matrix. 

I am looking for suggestions on how to create this in PowerBI.

Thank You,

Michael

[CoreyP]

It's possible but it won't look exactly like that with them side by side. But if you use Year from your date table in the rows, and Store from your store dimension table in the columns, then your measures in the values sections of the matrix visual, it will work. It will have each measure side by side within each Store category.

[mikebi]

Hello,

Yes it will look like this but they want it separate.

Michael

[CoreyP]

Additionally, use dynamic measure format strings to properly format the different results, like so:

[CoreyP · Accepted solution]

Well, it looks like we can get fun with DAX to accomplish this:

Your model should look something like this:

You'll need a table like this:

Build your matrix like this:

And make sure you expand all levels: