Average of most counted category

[Anonymous]

Hey, I need help here.

I am new in using power bi.

I have data like this:

I created the category using a "new column" by using the If function based on the value.

Basically what I want is, I want to create a card visual that shows only average from the largest counted category (in that case is group 2).

thank you

[Gordonlilj · Accepted solution]

Hi,

You could use the filter on the visual to show top n category like below

Or if you want to create a measure you could perhaps use a code like this

Measure = 
CALCULATE( AVERAGE( 'Table'[Value] ),TOPN(1, VALUES( 'Table'[Category] ), 
           CALCULATE( COUNT( 'Table'[Category] ) ), DESC ))

[Anonymous]

it works!

thank you for your help 🙏