Matrix Table - Data Transformation to Support

[justinharter]

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

MATRIX I WOULD LIKE

Any high level guidance would be appreciated.

[MFelix · Accepted solution]

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:

regards,

MFelix

[justinharter]

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?

[justinharter]

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