How to debug temporary table in a measure ?

[admin_xlsior]

Hello guys,

I have a measure which in its calculation having a temporary table, like this :

Inv. aging = 
VAR TmpTable = ADDCOLUMNS(
                           SUMMARIZE(
                                    'Inventory-Transactions','Inventory-Transactions'[Item id], 'Inventory-Transactions'[Transaction date]
                           ), "TmpAging", IF([Aging days] < 0, 0, [Aging days])
)
RETURN CALCULATE(
                SUM('Inventory-Transactions'[Inventory value]),
                FILTER(
                        TmpTable,
                        COUNTROWS(
                                    FILTER('Aging Interval',
                                    [TmpAging] >= 'Aging Interval'[From] &&
                                    [TmpAging] <= 'Aging Interval'[To]
                                    )
                        ) > 0
                )                
)

Question is how to know what is list of this temporary table TmpTable ?

The usage of this measure is in my matrix visual, which the row is the 'Inventory-Transactions'[Item id], but there is something wrong in the result which makes me want to take a look first what actually inside the TempTable.

So probably can forget first the CALCULATE thing below it.

Thanks in advance.

[bcdobbs · Accepted solution]

If you install DAX Studio you can query it directly by putting EVALUATE in front of it. Eg 

EVALUATE

ADDCOLUMNS(
                           SUMMARIZE(
                                    'Inventory-Transactions','Inventory-Transactions'[Item id], 'Inventory-Transactions'[Transaction date]
                           ), "TmpAging", IF([Aging days] < 0, 0, [Aging days])
)

You might also have to wrap it in CALCULATETABLE to recreate your filter context.

[bcdobbs]

You might find this useful:
Writing DAX Queries (daxstudio.org)