Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Debugging a virtual table (ie. in a variable)

I'm working on measures using ALL that reference tables and columns from tables, and I'd like to see explicitly what are the intermediate / virtual tables rather than just see the output of the final measure calculation

 

Is there a way to do this?

 

I'm trying to find one, using DAX Studio, but I can't find a way

 

E.g. if I was working in SQL, I'd just extract part of the query (or a subquery or CTE) and run it as a standalone query

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi - thanks for responding.

       

      As a simple example, how would you look at the table in the second part of this formula:

       

      Measure_1 =

      CALCULATE(

      [Measure_2],

      FILTER(

      ALL('Sales'),

      Sales[ID] = 001

      )

      )

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        According to your example, do you want to see the output of the filter section? You can just create a calculated table:

         

         

         

        table = FILTER(ALL('Sales'),Sales[ID] = 001)

         

        About how to use Dax studio, please refer to  https://exceleratorbi.com.au/getting-started-dax-studio/

         

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

        Best Regards,

        Dedmon Dai