Error with table connection

[AmitM]

Hi,

My model consists of 3 "fact" tables and several information tables (such as products, sites and so on).

I tried to connect these 3 fact tables to the "sites" table using "factory" column as a key.

The strange thing is that the connection works for just 1 of the fact tables.

When I use the "Factory" key (from sites table) as the ROWS of the pivot with the "good" fact table (table1<gs id="340986d9-f01e-4656-979d-c9db4f424cf4" ginger_software_uiphraseguid="51d684df-ebe5-40eb-bf6b-1598a6347738" class="GINGER_SOFTWARE_mark">)</gs>- it does display the result.

However, when I drag and drop the second table (Table2) to that pivot, I get an additional (blank) row that sums all the Qty instead of slicing the data by <gs id="abb925b4-2d1d-4826-ac73-28b94934462a" ginger_software_uiphraseguid="4056cdbf-bd19-4392-a65f-d2c21df71a8b" class="GINGER_SOFTWARE_mark">Factory</gs>.

Find a copy of the pivot:

		2008		2009		2010		2014		2015		2016
	Row Labels	Qty	Sum of TotalQty	Qty	Sum of TotalQty	Qty	Sum of TotalQty	Qty	Sum of TotalQty	Qty	Sum of TotalQty	Qty	Sum of TotalQty
Table1	Factory1								10850874		11674323		10493173
Table1	Factory2								10914534		11635265		10393721
Table1	Factory3								10771032		11824083		10494397
Table2	(<gs id="160ee25b-8464-443b-9e9f-1135ca31d784" ginger_software_uiphraseguid="6bc84b7a-88ba-4b7a-bb33-6792235e8590" class="GINGER_SOFTWARE_mark">blank</gs>)	1638095		2008700		654835		2454634		2309044		2389847

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[ImkeF]

Hi Amit,
what does it do, if you only take the measure from your table 2 (no data from table 1)?

Imke

 

[AmitM]

returns the #figure and (blank) in the ROWS or HEADERS

 

[AmitM]

Hi Amit,
what does it do, if you only take the measure from your table 2 (no data from table 1)?

Imke

returns the #figure and (blank) in the ROWS or HEADERS

 

[ImkeF]

This would happen if your Fact Table2 doesn't have any match with the "factory" key from your "sites" table.

Check if they really match and have the same format (are they alphanumeric? - check for blanks!)

 

[AmitM]

This would happen if your Fact Table2 doesn't have any match with the "factory" key from your "sites" table.

Check if they really match and have the same format (are they alphanumeric? - check for blanks!)

I did... they match, and that is why it is so strange

 

[ImkeF]

Are they connected by a pure star-scheme?

If not, delete all other connections, try if it works with pure star scheme and add the other connections 1 by 1, checking which one causes the blanks.

 

[scottsen]

I did... they match, and that is why it is so strange

Do it again.

In the fact table that is not working... add a calc column. Something like: =RELATED(Sites[SomeColumn])

The expectation is you get something valid for every row. What will actually happen is some blanks. Filter down to those blanks and figure out why they aren't in your Sites table...