When load more data, measure not work

[wangjuan303]

Hi , I have dashboard, is Direct Query connection, in the test DB, have 45 million rows,  I create a measure for find top 10 , when I just filter report, it load less data, this measure will works fine, when I clean this filter, load all related top 10, this report will show data with error, and some filter not work, I am not sure this related DAX , or related Power bi Direct query data limited, if anyone have good suggestion, please let me know, Thank you.  first picture data all right, and just have "AA" related top 10, second picture, when I remove "AA" filter, try to show all related data, then rank and filter for 11 all not work, and at same time, data not show the digest one, some data miss in this report .   

[V-lianl-msft · Accepted solution]

I tested it in a small data set, and the formula work fine.The issue in your dataset may be caused by query performance of too large dataset.

https://www.bluegranite.com/blog/how-to-improve-power-bi-performance-part-one 

[wangjuan303]

Thank you, you are right, our report has a default setting for Direct query connection, after change this setting, now all works, 

[PaulDBrown]

What is the RANK measure? How is the model set up?

[wangjuan303]

rank is similar like this patten,  data model is no relationship, only one big table

Rank Product =

IF (

    ISINSCOPE( 'Product'[Product Name] ),

    RANKX (

        CALCULATETABLE (

            VALUES ( 'Product'[Product Name] ),

            ALLSELECTED ( 'Product'[Product Name] )

        ),

        [Sales Amount]

    )

)