Forum Discussion
Expanded Table for Many To Many Relationship?
When I do a test to see if the columns from the dAuthor and BridgeAuthorBooks (Bridge Table) are present in the fSales Expanded Table, I created the measure:
=COUNTROWS(fSales)
then when I:
1) Use dBooks BookID Column in a PivotTable, and I get the correct count for each BookID.
2) Use dAuthors AuthorID Column in a PivotTable, and I get the wrong count, I get the count of all records in the fSales Table.
3) Use BridgeAuthorBooks AuthorID or BookID Columns in a PivotTable, and I get the wrong count, I get the count of all records in the fSales Table.
This test confirms that the dAuthor and BridgeAuthorBooks (Bridge Table) are NOT present in the fSales Expanded Table, right?
Sincerely, Mike Girvin
Any chance you upload some sample data? The concept of expanded tables is not an easy one and would like to look at the actual data if possible.