Forum Discussion

Matan's avatar
Matan
Frequent Visitor
7 years ago

Optimize DAX Measure

Hi,   I experience slowness when i'm trying to create a measure of estimate data which is build from: Actual SAP until date of update + Manual Forecast data (*date greater than Actual max date) ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Matan

 

You can try to download DAX Studio from http://daxstudio.org

 

You can analyse the query performance using this and then make the necessary changes.

 

If you can share the pbix in One Drive or Google drive and paste the link I can take a look at it .

 

 

Cheers

 

CheenuSing

 

 

  • Matan's avatar
    Matan
    Frequent Visitor
    7 years ago

    Hi Anonymous,

     

    Here is the Sample File

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Matan,

       

      I  checked the file using DAXStudio, the measure Estimated takes only 52 ms.  Please let me know where you find the slowness.

       

      Is it when building a table / matrix table or bar chart or line chart.

       

       

      Cheers

       

      CheenuSing