Index function working fine in Desktop and not in Power BI Service after data refresh

[gpmathad]

We have been using Index function in Power BI report. Everything is working fine  in Desktop.

However when we publish this report and on refreshing the report with Prod data, the values for same index are not matching.

Please see the image below. When I select Index 25, its giving me two different numbers though the source data is from same table. Source table has been imported twice in Desktop to test the index functionality.

Note: This data source has count of apprx 2 lac records.

[v-chenwuz-msft]

Hi @gpmathad ,

It works fine with me and I can not reappear your issues, please share more details about your model, the measure or some example data.

Another way, you can just copy the table1 again on power bi service and watch over the result if changed.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.