topic Re: Show repeating values from disconnected table using a DAX table function in DAX Commands and Tips

Show repeating values from disconnected table using a DAX table function

Anonymous — Wed, 21 Aug 2024 21:21:36 GMT

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?

Re: Show repeating values from disconnected table using a DAX table function

tamerj1 — Wed, 21 Aug 2024 22:42:17 GMT

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.

Re: Show repeating values from disconnected table using a DAX table function

Anonymous — Thu, 22 Aug 2024 15:21:51 GMT

Thank you! this helped immensely