Forum Discussion

Foram's avatar
Foram
Frequent Visitor
6 years ago

Not calculating max value for all the rows

Not calculating all the max value records correctly. There are few rows wherein the max values are incorrect whereas in most of the records it is calculating correctly. The formula used for calucat...
Need Help
zoloturu's avatar
zoloturu
Memorable Member
6 years ago

Foram ,

Please provide a sample data as well. And a column with expected result values.


Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer

Foram's avatar
Foram
Frequent Visitor
6 years ago

Here i'm attaching my sample file url.

 https://drive.google.com/open?id=1kYiOk_9HMAiXA6tEpFFjxY1AvquL6G22 

Considering 3 columns: Max Value, In(Mbps)  &Out(Mbps) 

Max value is derived in power bi desktop using Max Value = MAX([In(Mbps)],[Out(Mbps)]) formula.

Now if you check last 2 rows the value is incorrect in MAX VALUE Column but for the above rows it is correctly calculated. Let me know if i need to change the formula. I tried reverse formula also Max Value = MAX([Out(Mbps)],[In(Mbps)]) but didn't work.

 

And if you see MAX(Mbps) column it has the correct value which i've calculated using python.  

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Foram ,

    Please share a pbxi file for test, I create some test data but I can't reproduce your scenario. In addition, what version of power bi desktop are you test? Can you please share some more detail information?

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • Foram's avatar
      Foram
      Frequent Visitor
      6 years ago

      Hi,

      Thank you for your quick reply.

      My current version is  2.75.5649.861 64-bit (November, 2019)

      This issue is produced when i export the underlying data from power bi service.

      So in this case can you help me how to share it with you.

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI Foram ,

        Unfortunately, I still can't reproduce this. Where are you power bi data host? I think it may be related to your service data, maybe you can open a support ticket for further support.

        Regards,

        Xiaoxin Sheng