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.
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.
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 |
---|---|
103 | |
103 | |
87 | |
73 | |
67 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |