Forum Discussion
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
Community 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.
- bcdobbs
Community Champion
You might find this useful:
Writing DAX Queries (daxstudio.org)