In average how many rows repeat

[Chapin4u]

Hi, I need help with the following:

Have numeric column named Bid#. Each Bid# can be repeated n times.

• Need as a measure to know on average there are in Bid# column
• Need the measure to know the max of rows a Bid# has

Many tks for the help.

[Chapin4u · Accepted solution]

Thk Greg for the tip. i did the following and it worked.

averagex bid =
AVERAGEX (
ADDCOLUMNS ( SUMMARIZE ( Datos, Datos[Bid #] ), "Promedio", [Count Bid#] ),
[Promedio]
)

[Greg_Deckler]

Check out SUMMARIZE coupled with AVERAGEX or other "X" functions. Alternatively, check out GROUPBY with the "X" functions. Sample data and such would be helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Chapin4u · Accepted solution]

Thk Greg for the tip. i did the following and it worked.

averagex bid =
AVERAGEX (
ADDCOLUMNS ( SUMMARIZE ( Datos, Datos[Bid #] ), "Promedio", [Count Bid#] ),
[Promedio]
)

[Ashish_Mathur · Accepted solution]

Hi @Chapin4u,

You may not need the ADDCOLUMNS() function.  Try this

=AVERAGEX(VALUES(Datos[Bid #]),COUNT(Bid #))

or 

=AVERAGEX(SUMMARIZE(VALUES(Datos[Bid #]),[Bid #],"Promedio",COUNT(Bid #)),[Promedio])

Hope this helps.