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 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.

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

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    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.