Forum Discussion

kbsmx's avatar
kbsmx
Frequent Visitor
5 years ago

RANKX By Group In Measure for Push Dataset

I have a push dataset (single table with history enabled; the default RealTimeData table name) with a schema similar to the example below.  Notice that there are four rows per site; one for each serv...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

kbsmx's avatar
kbsmx
Frequent Visitor
5 years ago

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.