Hello, I have a problem because I have just begun to handle on Power BI
My personal project is to build a small database to make my historical researches in archives easier:
inside administration, some documents are sent to multiple administration's departments /individuals AND departments/ only individuals. I want to know what documents are sent to, and how many times.
Example: document 1 was sent to John directly, and a second time to John, indirectly, through a group in which John is.
In the Power BI report, in front of John, I want "document 1" to be mentionned 2 times, into 2 subcategories (directly, and the name of the group)
I have built a relational database with power BI. Unfortunately, my report always display "document1" once. As if Power BI only chose to display non redundant values only.
My database structure: 5 tables. The example is about one document for one person, but I have to elaborate tables structure for many-to-many relations cases (I don't face issue related to that)
- document with primary key for each
- table with document key and key for person (John in the example)
- table with list of persons and corresponding primary key
- table with document key and group key
- table with group key and corresponding person key
What is the solution ? Any advices ?
My personal project is to build a small database to make my historical researches in archives easier:
inside administration, some documents are sent to multiple administration's departments /individuals AND departments/ only individuals. I want to know what documents are sent to, and how many times.
Example: document 1 was sent to John directly, and a second time to John, indirectly, through a group in which John is.
In the Power BI report, in front of John, I want "document 1" to be mentionned 2 times, into 2 subcategories (directly, and the name of the group)
I have built a relational database with power BI. Unfortunately, my report always display "document1" once. As if Power BI only chose to display non redundant values only.
My database structure: 5 tables. The example is about one document for one person, but I have to elaborate tables structure for many-to-many relations cases (I don't face issue related to that)
- document with primary key for each
- table with document key and key for person (John in the example)
- table with list of persons and corresponding primary key
- table with document key and group key
- table with group key and corresponding person key
What is the solution ? Any advices ?
