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 calucation of max value is: 

Max Value = MAX([In(Mbps)],[Out(Mbps)])
May i know if this the correct formula i'm using because this is the basic formula.
 
Thanks is advance
Need Help

5 Replies

  • 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