Forum Discussion

Maradh's avatar
Maradh
Icon for Helper I rankHelper I
6 years ago

Power BI service showing wrong values

Hi,


I don't know if it's a bug or not but im having a lot of trouble trying to make specific report (with the specific OneDrive update) on Power BI service.

My goal is to show the most recent value by personal Id but i find it to be impossible with what Power BI web service has to offer, here is some screenshots :

 

In the screenshot above, i display all number of rocks and you can see what each number of rocks has for Date and hour (most recent)


In this one, i display the sum of all number of rocks

 

This one is the minimum number of rocks

 

And finally, this screenshot with the max number of rocks but with the wrong Date and hour (most recent) which is the same date/hour as the minimum value

I don't know, maybe Power BI web service has too much restriction, can anyone help ?

Need Help

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Most recent value generaly goes something like this:

     

    Measure =
  VAR __ID = MAX([Personal ID])
  VAR __MostRecent = MAXX(FILTER('Table',[Personal ID] = __ID),[Date and hour (most recent)])
RETURN
  MAXX(FILTER('Table',[Personal ID] = __ID && [Date and hour (most recent)] = __MostRecent),[Number of rocks])
    • Maradh's avatar
      Maradh
      Icon for Helper I rankHelper I
      6 years ago

      Yeah but the problem is that i can't create measure since i can't work on Power BI desktop for this specific case because i need to use the Onedrive update (the one which is set with only one file in Onedrive business)

       

      So the way i try to get the value i want is through filters or data fields like not resuming, sum, max, min, most recent, etc. But it seems it doesn't work the way it is supposed to.

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Maradh ,

         

        This should not be a bug, but a normal summary of the data.

        You can use Web connector to connect to OneDrive, then, publish your report to Power BI Service.

        For the [most recent], you may need to create a measure to return the date and hour. 

        Use OneDrive for Business links in Power BI Desktop 

         

        Best regards,
        Lionel Chen

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