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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

duybachhpvn ,

Any solution worked out for you?

Do the above replies help? if you need more help make me @

Appreciate your Kudos.

  • 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