How to present result from two matrixes in a common matrix

[Lorentzt]

I am new to Power BI and are working on moving my old Excel (power pivo) reports to Power BI. Most of that works well, but i have encountered a problem. 

I have a montly report of all active support tickets for a customer. (created the 1st in every month for a previous month)

I have a custom column that shows all tickets that was open the last month and it gives me the complete ticket list 🙂

On the front page i used to have a table given information on the status at mont start, end and new/closed tickets.

 In PowerBI i manages to get this split into two diferent queries by checking if a ticket was created last month or closed last month. As a ticket both has a created periode and a closed periode i dont see how i can use one column value to split between the rows in the presentation.

Created_Last_Month:False = Tickets at start of periode

Created_Last_month:True  = New tickets in periode

Closed_Last_Month: True  =  Closed tickets in periode

Closed_Last_Month: False = Open tickets at periode end.

In Power Pivo i solved this by creating two Power Pivo's and then assigned the presentations values by poiting to the diferent cells in the power pivo's.

Any ideas, sugestions is very welcome.

[Lorentzt]

Searching the forum i found a post about using Measurement for sorting values and it looked like a possible solution. Sharing the solution and result below for others that may need it :).

I created a measurement using countrows and filter for each of:

Start, New, Closed, Remaining.

This gave me this promising result:

So now i had a usable presentation, but i wanted type to be shown as columns so i moved 'Type" fra rows to columns but the result wasnt as wished:

This problem was possible to fix by changing the Values parameter "Show on rows" to true.

This looks good:

The only challenge now is how can i order the columns in my prefered order?

[vanessafvg]

@Lorentzt create a new column for the sort order  so depending on what you order you want you can either create a calculated column with a switch statement or manually create it in power query - does that make sense?

then in your modelling table in power bi set the sort of that column by the column ie