Forum Discussion
Ignore Row Hierarchy in Matrix
Hello, everyone
I need the percentage range to be group by project and not by employee. In the example, projects 2 and 3 are displayed in the two matrices. I need the percentage of projects to be displayed by the average number of employees on each project.
In matrix 1 the percentage of project 2 is 99.31 and in matrix 2 project 2 has the percentage of 89.30. The average of project 2 should be 97.49% and appear only in matrix 1.
2 Replies
Hey Millene ,
to be honest, I have no idea what your expected result is.
Please prepare that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix file to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.
Explain the expected result based on the sample data, e.g. how the average for project 2 is calculated, why you expect it only in matrix 1, and of course what's the difference between matrix 1 and matrix 2.Regards and a Merry Christmas,
Tom
Hello, Tom
The range should only consider the project average and not employee values. Below is a before and after image. The range side filter was applied on each array, I need it to be applied to project only, ignoring employee values.
