Forum Discussion

CJ_96601's avatar
CJ_96601
Icon for Helper V rankHelper V
4 years ago
Solved

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.   BN AMOUNT 1 1000 1 2000 1 3000 2 1000 3 2000...
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    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.

     

  • PC2790's avatar
    PC2790
    4 years ago

    You can visualise it like this:

     

nasolme's avatar
nasolme
Icon for Helper I rankHelper I
4 years ago

Hi !

average = AVERAGE('Table'[amount])
max = max('Table'[amount])

 

 
  • CJ_96601's avatar
    CJ_96601
    Icon for Helper V rankHelper V
    4 years ago

    Thanks.  But this is the result i expect.

     

     

    13000
    23000
    34000
    44000
    54500
      
    Average3700
    • PC2790's avatar
      PC2790
      Icon for Community Champion rankCommunity Champion
      4 years ago

      You can visualise it like this: