Forum Discussion
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...
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.
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.
THank you Steve! This worked very well!