Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sum up the difference in Maximum and minimum value per meter group

Please assist me with a measure to calculate the total hours in the below table using the logic below. i used the dax below , but my subtotal in the table is not summing up.   SMU Hrs = IFERROR( CA...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi Pragati11,

what will be the logical logical test for mth IF .

 

thanks 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Anonymous Didn't understand the question.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi Pragati11 ,

     

    I created two measure, as below.

     

    Max End Reading = MAX([End Reading])

    Min Start Reading = MIN([Start Reading])

    how do i calculate the total of the difference required based on the Meter?

     

    thanks 

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      6 years ago

      Hi Anonymous ,

       

      Apologies. But I thought you were looking for following calculation:

      Total Hours = Difference between Maximum end reading and minimum start reading when meter is HRS ,Difference between Maximum end reading and minimum start reading when meter is HRS1.

       

      Can you please elaborate your question on the following:

      how do i calculate the total of the difference required based on the Meter?

       

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI Pragati11 

       

      Yes i am after the sum of the differences, but i am not geting the required results.

       

      thanks

      • Pragati11's avatar
        Pragati11
        Icon for Super User rankSuper User
        6 years ago

        Hi Anonymous ,

         

        You can create a 3rd measure as:

        Sum1&2 = Max End Reading + Min Start Reading

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi Pragati11 ,

      I created a third measure using SUMX, and that is working fine.

      Total Hours = Sumx(values(EngineReading[meter], calculate (max(EngineReading[StopReading])) - CALCULATE(MIN(EngineReading[StartReading])))

      Except that my subtotals in the matrix visualization is incorrect .

       
       

      How do i fix that.

       

      Thanks for the help