Show repeating values from disconnected table using a DAX table function

[Anonymous]

Hello All,

I have a dimenstion table (Table A) and 2 fact tables (Table B and C) but the dim table is only connected to Table B.

I know the common result that occurs if you create a table visualization using the dim table and the fact tables would be repeating values for the disconnected table and the context filtering table B.

My question is, is there a way to recreate that using summarize() or another dax table expression? I want to recreate the repeating values using the table expression. 

If I use summarize(), an error occurs if i reference table C's column. Is there another table function I can use?


  

[tamerj1 · Accepted solution]

Hi @Anonymous 

I would suggest to simply copy the DAX query that the engine generates to produce the table visual. Use the Performance Analyzer. SUMMARIZECOLUMNS is the function that does that. 

[Anonymous]

Thank you! this helped immensely