DAX HELP TO CREATE A NEW TABLE

[Istiak_Ahmed]

i have this data model ,

i want to create a Newtable where i have columns dim_document [title], fact_document[id],dim_journal[name],dim_audience[description], 

*can not add the dim_audince[description] with the new table*

[Anonymous]

Hi, @Istiak_Ahmed 

What fields are at play in the relationship you are describing, and can you give the data necessary to create a new table in a tabular format?

Best Regards,
Yang
Community Support Team

[Istiak_Ahmed]

hey, thank you for your response

FACT_DOCUMENT [DOCUMENT_ID]-------------->DIM_DOCUMENT[ID]

FACT_DOCUMENT [JOURNAL_ID]--------------> DIM_JOURNAL[ID]

DIM_JOURNAL[ID] ------------------> DIM_JOURNAL_AUDIENCE [JOURNAL_ID]

DIM_JOURNAL_AUDIENCE [AUDIENCE_ID]---------------->DIM_AUDIENCE[ID]