cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CJ_96601
Helper V
Helper V

Maximum and Average

Measure to get the maximum amount for each BN and then average the maximum amount.

 

Below is the sample data for reference.

 

BNAMOUNT
11000
12000
13000
21000
32000
43000
23000
34000
44000
1500
33500
54500

 

Appreciate your help.

2 ACCEPTED SOLUTIONS
PC2790
Super User
Super User

I think you are looking for this:

Average of Max values as per BN = AVERAGEX(SUMMARIZE(BNTable,BNTable[BN],"MaxBN",MAX(BNTable[AMOUNT])),[MaxBN])

It gives an outcome of 3700 with the given data.

 

View solution in original post

You can visualise it like this:

PC2790_0-1650610191099.png

 

View solution in original post

5 REPLIES 5
PC2790
Super User
Super User

I think you are looking for this:

Average of Max values as per BN = AVERAGEX(SUMMARIZE(BNTable,BNTable[BN],"MaxBN",MAX(BNTable[AMOUNT])),[MaxBN])

It gives an outcome of 3700 with the given data.

 

Thanks. 

this is the result i was looking for.

Now, what if i would like to get with code "BS" only.

Below sample refer.

 

BNAMOUNTCode
11000BS
12000BS
13000H
21000BS
32000BS
43000BS
23000H
34000BS
44000BS
1500BS
33500H
54500BS
nasolme
Helper I
Helper I

Hi !

average = AVERAGE('Table'[amount])
max = max('Table'[amount])
Capture d’écran 2022-04-19 125838.jpg

 

Thanks.  But this is the result i expect.

 

 

13000
23000
34000
44000
54500
  
Average3700

You can visualise it like this:

PC2790_0-1650610191099.png

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.