Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Community Champion
Community Champion

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

PC2790
Community Champion
Community Champion

You can visualise it like this:

PC2790_0-1650610191099.png

 

View solution in original post

5 REPLIES 5
PC2790
Community Champion
Community Champion

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
PC2790
Community Champion
Community Champion

You can visualise it like this:

PC2790_0-1650610191099.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.