Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |