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 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
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.
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
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |