cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
justinharter Frequent Visitor
Frequent Visitor

Matrix Table - Data Transformation to Support

I am looking to create a Matrix table that has the following structure, but am unsure as to the easiest path to transform my data to support the structure. The data structure I have is below along with the matrix structure I would like. I could have a job run that summarizes the data like the matrix I want, but was wondering if I can do it directly in Power BI.

 

DATA STRUCTURE

data.PNG


MATRIX I WOULD LIKE

matrix.PNG

 

Any high level guidance would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Matrix Table - Data Transformation to Support

Hi @justinharter,

 

Create the following measures:

Total Incidentes = CALCULATE(COUNT(Incident[Incident]))

Total Incidentes (Minus Event Category) = CALCULATE(COUNT(Incident[Incident]),Incident[Category] = "Incident")

% Incidents = DIVIDE([Total Incidentes (Minus Event Category)],[Total Incidentes])

Then add it to the matrix visual and should get what you need:

 

Matrix.png

 

regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




3 REPLIES 3
Super User
Super User

Re: Matrix Table - Data Transformation to Support

Hi @justinharter,

 

Create the following measures:

Total Incidentes = CALCULATE(COUNT(Incident[Incident]))

Total Incidentes (Minus Event Category) = CALCULATE(COUNT(Incident[Incident]),Incident[Category] = "Incident")

% Incidents = DIVIDE([Total Incidentes (Minus Event Category)],[Total Incidentes])

Then add it to the matrix visual and should get what you need:

 

Matrix.png

 

regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




justinharter Frequent Visitor
Frequent Visitor

Re: Matrix Table - Data Transformation to Support

Thanks for the reply @MFelix. When creating the measures and putting them in the matrix as you have them, I do not get the same result for the Matrix. Is there something else I need to change?

 

issue.PNG

justinharter Frequent Visitor
Frequent Visitor

Re: Matrix Table - Data Transformation to Support

I've figured it out @MFelix. I see you simply need to turn on row groups in the properties of the matrix.