Forum Discussion

justinharter's avatar
justinharter
Frequent Visitor
8 years ago
Solved

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 wi...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    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's avatar
justinharter
Frequent Visitor
8 years ago

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's avatar
justinharter
Frequent Visitor
8 years ago

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