Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ovonel
Post Prodigy
Post Prodigy

I am confused by performance analyzer?

The exact same visual sometime it takes:

ovonel_0-1675178492441.png

 

and sometimes it just takes:

ovonel_2-1675178552001.png

 

How is it possible?

 

 

Both are executing the exact same DAX query:

 

 

 

// DAX Query

DEFINE

  VAR __DS0FilterTable =

    TREATAS({"Engagement Manager"}, 'Engagement Role'[Engagement Role])

 

  VAR __DS0FilterTable2 =

    TREATAS({"Tim J"}, 'Employee Current'[Name])

 

  VAR __DS0FilterTable3 =

    TREATAS({"FY23 - 07 - Dec"}, 'Date'[FY and Month])

 

  VAR __DS0FilterTable4 =

    FILTER(

      KEEPFILTERS(VALUES('Date'[Month Offset])),

      AND('Date'[Month Offset] < 0, 'Date'[Month Offset] > -2)

    )

 

  VAR __DS0Core =

    SUMMARIZECOLUMNS(

      'Key Figures Header'[Header],

      'Key Figures Header'[SortOrder],

      __DS0FilterTable,

      __DS0FilterTable2,

      __DS0FilterTable3,

      __DS0FilterTable4,

      "Key_Figures_LTM", 'Calculations'[Key Figures LTM],

      "Key_Figures_LTM_LY", 'Calculations'[Key Figures LTM LY],

      "Key_Figures_Dev__LY", 'Calculations'[Key Figures Dev. LY],

      "Key_Figures_Growth__", 'Calculations'[Key Figures Growth %]

    )

 

  VAR __DS0PrimaryWindowed =

    TOPN(501, __DS0Core, 'Key Figures Header'[SortOrder], 1, 'Key Figures Header'[Header], 1)

 

EVALUATE

  __DS0PrimaryWindowed

 

ORDER BY

  'Key Figures Header'[SortOrder], 'Key Figures Header'[Header]

 

 

 

The only difference is that in the execution that takes LONGER , I am removing myself from the 'Read all' role, and I guess I can't jump over the RLS stuff... but i dont get why no RLS dax code is shown, if that is what is making it so slow....

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.