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
parry2k's avatar
parry2k
Super User
5 years ago

kbsmx seems like I'm missing something here but let's start the solution. I created a measure called FILTERMAXDATE and used MFelix file, so Site A has a max date of 19th, B - 17th, and C - 15th and used a visual level filter on this measure where value = 1 (see attached).

 

If this doesn't work in your Push Dataset scenario, provide more context with screenshots of what is not working,  and what are the expectations with sample data.

 

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

 

  • kbsmx's avatar
    kbsmx
    Frequent Visitor
    5 years ago

    parry2k MFelix - Here's what's happening:

     

    Refresh while dataset update in progress:

     

     

    Refresh after dataset update complete:

     

     

    The push dataset is updated every 5 minutes.  It takes approximately 1 minute for all new rows to be committed to the dataset, and each site's rows are pushed to Power BI in a single batch per site.  So if the user views the report at some point during that 1 minute of pushing data, some sites may still have the previous refresh/status date and therefore aren't shown in the visual as filtered using the provided sliding date window.