Forum Discussion
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
Community 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.
- AnonymousNot applicable
Thank you! this helped immensely