Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Show repeating values from disconnected table using a DAX table function

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?


  

 

  • 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. 

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    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's avatar
      Anonymous
      Not applicable

      Thank you! this helped immensely