Forum Discussion
Dax question: Save as table
Hello could anybody help me with dax query?
I have table in pbix file like this:
This table includes Region column pulled from one table and Margin total measure, which evaluates margin based on complex expression from different tables.
I would like to store this result in a table or temporary table RESULTS and one more column from table Plan to this table RESULTS.
Is it possible to do such thing? if yes, could anybody provide me query please?
Thx
2 Replies
Normally I would point you torward CALCULATETABLE but I do not believe you can reference a measure with that function:
https://technet.microsoft.com/en-us/library/ee634760(v=sql.105).aspx
To get that table, you may use a created table and then add a calculated column as
#calculated table
Result = all(RegionTable[region])
#calculated column
Margin Total =
CALCULATE (
MarginTotalMeasure,
FILTER ( RegionTable, RegionTable[region] = 'Result'[region] )
)Or maybe you can aggregate via SUMMARIZE and samples.
If above approaches don't work, please be more specific on your scenario. Post table details with sample data and the MargionTotalMeasure formula.
