Average loop type per project

[harshagraj]

HI all, I need average loop type for the below table. loop_type column is a dimension. Thanks in advance.
Need to display this in a card. I have a project slicer to filter.

Project	ToolNo	loop_type	Count of loop_type
PRJ-16	28-178	Planned Loop	2
PRJ-17	28-179	Finished Loop	4
PRJ-18	28-180	Finished Loop	6
PRJ-19	28-181	Planned Loop	1
PRJ-20	28-182	Planned Loop	1

[amitchandak]

@harshagraj , not very clear

averagex(values(dim[Project]),max(Table[Count of loop_type]))

or
averagex(summarize(dim[Project],"_1",max(Table[Count of loop_type])),[_1])

[harshagraj]

Hi @amitchandak thanks for the reply. Actually i dont have [Count of loop_type] column i just changed that in value shelf from a table and dragged. 

[amitchandak]

@harshagraj , Not very clear, what you need?

[harshagraj]

Sorry for the trouble. I have Project Number,Tool Number,Loop Type as columns.
In Loop Type column i have values as (Finished & Planned). Each tool number will have one loop type. So i need Averge loop type per project.
Eg.

PRJ-19	21-18	Finished Loop
PRJ-19	21-19	Planned Loop

So this has 1 Finished and 1 Planeed. So i need to display Average loop as 1.

[amitchandak]

@harshagraj , in case you need column. Both as new columns

Loop count = countx(filter(Table, [project] earlier([project]) && [loop type] = earlier([loop type])),[loop type])
Avg Loop =AverageX(filter(Table, [project] earlier([project])),[Loop count])

If a measure , refer - make is Avg or count

https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013

[harshagraj]

Hi @amitchandak thanks for the solution. But it is need working please correct the highligted error
 countx(filter(Table, [project] earlier([project]) && [loop type] = earlier([loop type])),[loop type]).

[amitchandak · Accepted solution]

@harshagraj 

Loop count = countx(filter(Table, [project] =earlier([project]) && [loop type] = earlier([loop type])),[loop type])
Avg Loop =AverageX(filter(Table, [project] =earlier([project])),[Loop count])