Forum Discussion

Tu's avatar
Tu
Regular Visitor
3 years ago

Slow performance when using a column from Dimension table as Measure

Hi all, I have a Fact table and 3 dimension tables.  And I need the report to be displayed in Matrix format like below.   DimProduction[ProductionID] DimMaterial[Material] DimDate[Date...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Tu ,

If I understand correctly, your report run very slowly after added the measure [ProductionStartDate] into the report. Am I right? What's its formula? And the following links are the ones which have the similar problem as yours, please check them. Hope they can help you resolve the problem.

Why my Power BI Matrix or Table Visual is SLOW - RADACAD

  • Performance Tune the Measure, Design a Proper Data Model
  • Consider Pre-Calculation--create custom column
  • Reduce The Number of Calculations

Solved: Slow performance of measure

I created the chart using the Date from the datedimension, and that was what ruined the performance, and makes sense. I changed the date to a precalculated date in the dimension, and used a Month-Year, a Year and a Week-Year on the x-axis, and that was part 2 of the solution.

 

I Guess that when using a simple date with a measure, the measure will try to recalculate every single possible point in the date dimension and that slowes it down ofcourse. So using a End-of-month date did the trick so to speak.

Best Regards