Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
gbernardes_
Frequent Visitor

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 sellers (40k rows).

 

The question is: how can I work with both of them? For example: sales by seller x on date y?

 

P.S.: I can't create a table with both seller and date because it would be huge as well (40k * 4k = 160 million rows).

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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?

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.