Forum Discussion

sophtee's avatar
sophtee
Helper I
2 years ago

Find the average for different ranges

Hello Everyone,

I would like to get the get the average of the %Hch. But to group the %Rej in ranges and have these values to be used. Below shows the dsplay of the data and how I would like to grop these values. 

So %Rej (0.00 to 0.2) Get the average %Hch and 

%Rej (0.21 to 0.25) Get the average %Hch.

 

Data Protection
Need Help

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Share the download link of the PBI file with the visual that you have sown already created in the file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi sophtee 


    Here is a method for your reference:
    Right-Click the field of the Column and select the new group:

    Then choose the List in the Group type. 
    Choose the values you want to group up, and click Group.

    At last, click OK. 


    And add a measure:

    Measure 2 = AVERAGEX('Table','Table'[%Hch])

    The result is as follow:

     

     

    Here for reference:

    Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn

     

    Best Regards

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

    • sophtee's avatar
      sophtee
      Helper I
      2 years ago

      Anonymous Hello,

      I tried this but use the bins to group the data at a range. I also used a meassure to calculate the average of each bin. Is there a way I can use this as a look up?

      For example if I have values I would like to look up data from the table above

      so if I have 1.80 as %Rej it would show 70.58 %Hch.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi sophtee 

         

        what is your measure and how you group up the data?
        Do you mean that if you choose 1.80(%Rej), the outcome returns the 70.58 whose %Rej(2.69) next and greater than 1.80?

         

        Best Regards

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