Relation in Data Model after aggregation

[Emre75]

when I aggregate data with groupby or summarize function in a new table , there is no relationship between the main table and new table in the data model. How can I establish this relationship?

[Emre75]

In the main table (which is quite a long table) there is time information for each row.

I group the values in one column and sum the values in another column for those groups. But when you do this (with summarize function), the relationship with time is lost. Any filtering in time is not reflected in this distribution.

[Wilson_]

Emre,

Maybe I'm missing something here, but include the relevant time columns in the SUMMARIZE function too then. Joining two fact tables together is generally not best practice; multiple fact tables may often both be joined to a common set of dimension tables though.

Hard to provide much help without more specific scenarios and more knowledge of your actual tables (both real and calculated) and/or context for why the calculated table is needed. 😄

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

[Wilson_]

Hello Emre,

Presumably, they're both fact tables so my question is why would you want to? Would you not instead create relationships between your dimension tables and the new calculated table?