Forum Discussion
Helper IIIWhen load more data, measure not work
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 .
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
4 Replies
PaulDBrownCommunity Champion
What is the RANK measure? How is the model set up?
wangjuan303rank 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]))
V-lianl-msftCommunity Support
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,