Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey I have a matrix that looks like this. %A-%E is a measure.
When I try to sort the columns in a different way using Sort by Col and choosing the Number values of the colums. Example would be A = 1, B = 2, C = 3, D = 4, E = 5. When I try to sort them all the percentage values become 1 or 100%. Would anyone know why this is happeneing?
The matrix:
|C %C E %E A %A D %D B %B Total %Total|
---------------------------------------------------------------
Ro | 1 .09 1 .09 4 .36 2 .18 4 .21 11 1
Ro | 2 .22 1 .11 2 .22 1 .11 5 .55 9 1
Ro | 3 .24 3 .24 1 .08 3 .24 6 .48 13 1
The Matrix after I try to sort them.
|A %A B %B C %C D %D E %E Total %Total|
---------------------------------------------------------------
Ro | 1 1 1 1 4 1 2 1 4 1 11 1
Ro | 2 1 1 1 2 1 1 1 5 1 9 1
Ro | 3 1 3 1 1 1 3 1 6 1 13 1
The Matrix I want:
|A %A B %B C %C D %D E %E Total %Total|
---------------------------------------------------------------
Ro | 1 .09 1 .09 4 .36 2 .18 4 .21 11 1
Ro | 2 .22 1 .11 2 .22 1 .11 5 .55 9 1
Ro | 3 .24 3 .24 1 .08 3 .24 6 .48 13 1
% of peeps = DIVIDE( DISTINCTCOUNT(Reporting_Query_v2[Individual_id]), CALCULATE(DISTINCTCOUNT(Reporting_Query_v2[Individual_id]), ALLSELECTED(Reporting_Query_v2[HighestAttainedStatusCode])))
It's quite strange. How did you make same entry ("Ro") on Row Group?
In Matrix, the Value field must aggregate on row group level, which means you only have one row for " Ro".
Can you share some sample data and screenshots?
Regards,