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...
Need Help
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