Forum Discussion

duybachhpvn's avatar
duybachhpvn
Frequent Visitor
5 years ago

Using SUMMARIZECOLUMNS as virtual table with dynamic filter context

Hi,   I have below measure that use SUMMARIZE to create a virtual table that has filter context dynamically change based on the visual context (for example, different quarters on a line charts). Th...
Need Help DAX
duybachhpvn's avatar
duybachhpvn
Frequent Visitor
5 years ago

Hi Amitchandak,

Unfortunately I cannot combine Summarize and SUMMARIZECOLUMNS. It seem that SUMMARIZECOLUMNS does not support dynamic filter context like SUMMARIZE does?

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You need to replace SUMMARIZECOLUMNS with SUMMARIZE, not use them together.  The error you are seeing is common with SUMMARIZECOLUMNS.  With SUMMARIZE, you will need to add the name of the table you are summarizing to your measure.

 

Regards,

Pat