Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Handling with two separated agg tables

Hi there. I have a huge fact table with approximately 200 million rows.   I need to reduce the model size by using aggregations. So I created two principal aggregation tables: dates (4k rows) and s...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Create a relationship (Many to One and Single) from the 2 Fact tables to the 2 Dim tables.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I did this, but it doesn't find the aggregation relationship between seller and date in the same table (obviously because they are in separate tables). Is there any way for the two tables to interact even though they are separate?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

      Share an abridged version of your PBI file and show the expected result very clearly.