Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
125 | |
42 | |
39 | |
28 | |
24 |