How to insert or get value after taking average?

[Anonymous]

Hello everyone,

I need little help with average. I want to create a column after taking average based on Projekt#Investor#. In the resulted new column, avg_betreuung, I want resulting value filled only first cell. Rest cell should be 0 or null.

For example, if Projekt#Investor# is wpd AG then only first cell of wpd AG  will be filled with the resulted average. is it possible.

Please kindly help.

Regards

Karim

[amitchandak · Accepted solution]

@Anonymous , The column I need take Average is not clear. So used

First add an index column- https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

and then this formula a new column in DAX

new column =
var _index = Minx(filter(Table, [Projekt#Investor#] =earlier([Projekt#Investor#])),[Index])
return
if([Index] =_index, averageX(filter(Table, [Projekt#Investor#] =earlier([Projekt#Investor#])),[betreuung]), blank())

[Anonymous]

@amitchandak first of all thank you very much for your reply. 

But unfortunately, I got blank for all. Please kindly check the picture.