Forum Discussion

miguelsus2000's avatar
miguelsus2000
Icon for Helper III rankHelper III
6 years ago
Solved

Need help extracting Max Value.

Hi,   I'm trying to create a column in the bottom table which displays the maximum value under "Count per BID" for every PartitionKey value.  For example, i selected PartitionKey 70b...120, and the...
  • stevedep's avatar
    stevedep
    6 years ago

    Hi,

     

    Perhaps I am oversimplifying things, but this is my result:

    MaxOfPartitionKey = maxx(SUMMARIZE('Table';'Table'[PartitionKey];'Table'[Identifier]);CALCULATE(COUNT('Table'[BID])))

     

    As can be seen here:

    Power BI file available here.

     

    Please accept as solution if this is what you are looking for. Thanks.

     

    Kind regards,

     

    Steve. 

stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

Hi,

 

Perhaps I am oversimplifying things, but this is my result:

MaxOfPartitionKey = maxx(SUMMARIZE('Table';'Table'[PartitionKey];'Table'[Identifier]);CALCULATE(COUNT('Table'[BID])))

 

As can be seen here:

Power BI file available here.

 

Please accept as solution if this is what you are looking for. Thanks.

 

Kind regards,

 

Steve. 

miguelsus2000's avatar
miguelsus2000
Icon for Helper III rankHelper III
6 years ago

THank you Steve!  This worked very well!