Forum Discussion
RANKX By Group In Measure for Push Dataset
parry2k MFelix - Any other ideas? This is affecting two different reports using two different push datasets. Because both datasets receive new data every 5 minutes, and it takes approximately 1 minute for the new rows to post, there's about a 20% chance every 5 minutes that a user will see the partial rendering which we need to avoid. I appreciate your help and understand that this is a difficult nut to crack.
HI kbsmx,
I think these should more relate to the Dax formula calculation on 'live' mode data source. These type of data table that update frequently, they may affect the dax formula calculations.
In my opinion, I'd like to suggest you direct calculate and append these results into the source data and push with these requests at the same time. It should reduce the effect of Dax calculation that hosts on frequent updates data sources.
Regards,
Xiaoxin Sheng
Anonymous Unfortunately, that's not possible. You can't precalculate the results for this type of filter as you can't query the data in Power BI to produce such a calculation nor can you update existing rows in a push dataset. This filter *must* be done in DAX based on the current push dataset API limitations.