Forum Discussion

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

How to debug temporary table in a measure ?

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.

 

  • 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.

2 Replies

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion

    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.