Find the average for different ranges

[sophtee]

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.

[Anonymous]

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]

@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]

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.

[Ashish_Mathur]

Hi,

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

[lbendlin]

Use PERCENTILEX.INC for the grouping.