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.
Hi,
I have 2 measures measure_1 and measure_2. Both utilize the exact same temporary variable table TempTable to calculate the final result. The calculation of TempTable is very heavy and depends on the filter context. Thus the exact same calculation is done TWICE, and it would make sense to reuse TempTable instead.
Is it possible to reduce total calculation time by 50% by e.g.
I'm using PowerPivot, but i'm also interested if it is possible in Power BI.
Thanks!
Thanks Antriksh, but I already spent several days optimizing the code with Dax Studio.
This is a huge weakness in DAX compared to an SQL stored procedure.
I have an idea for a partial workaround though in PowerPivot/Excel.
Step 1: EVALUATE the DAX code of TempTable in a worksheet connection in Excel.
Step 2: Query TempTable into the datamodel
Step 3: Calculate measure_1 and measure2
Subsequent problems
SUMMARIZECOLUMNS doesn't see any filter context if it runs through the "Edit DAX" on an Excel Table connected to the Data Model.
Seems like there is no solution to this issue.
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 |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
49 | |
45 | |
20 | |
16 |