Forum Discussion

sophtee's avatar
sophtee
Icon for Helper I rankHelper 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...
Data Protection
Need Help
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
    Icon for Helper I rankHelper 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.