Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks 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?
I've figured it out @MFelix. I see you simply need to turn on row groups in the properties of the matrix.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |