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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PaulTim
Frequent Visitor

Aggregation accross tables

Dear all,

 

I have a huge Data Model with 30 Tables linked via Keys (Hash-values) to a fact table. The fact table only contains the keys and no additional data and is therefore hidden. Transactial Data e.g. the values are part of an dimension same as master data tables.

 

It looks a bit like that 

 

Table FACT:

ID_A

ID_B

ID_C

 

Table A:

ID_A

Info_1

Info_2

Info_3

 

Table B:

ID_B

Info_4

Value_1

Value_2

 

Table C:
ID_C

Info_5

Info_6

 

We are having multiple hunderets of million of rows. Right now the data model is setup as DirectQuerry since import is not possible.

I was thinking of Aggregation but was not able to build something like that:

 

AggTable D via SQL Import:

Info_1

Info_5

SUM(VALUE_1)

 

Unfortunately I am not able to link Info_1 from Table1 with the AggTable due to an N:M relationship. Any Idea if on how to solve that?

1 REPLY 1
lbendlin
Super User
Super User

The fact table only contains the keys and no additional data and is therefore hidden. Transactial Data e.g. the values are part of an dimension 

that's not how these data models work.  The values must be taken from the fact table.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors