Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I need to create a report where I can display multiple granularity details in a single fields/column of a Matrix.
This basically means that some rows from the source table will be counted multiple times
Here is the example of the data:
So Far I have come up with these sutions:
I do not want to expand the rows of the source table to multiple rows, I want 1 row = 1 employee
I would prefer the first solution using Many to many relationship, because it seems the most efficient when it comes to writing the measures. But I am not sure of any future complications/implications this solution might bring.
I would like to know your opinion or maybe you have a different solution!
Thank you
Jakub
Solved! Go to Solution.
Your dimension table 2 needs to stay disconnected for this to work. Your composite key (table 1) is not required, and table 3 is not required either.
Repeating data in the same visual is a design red flag.
see attached.
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |