Forum Discussion
Average loop type per project
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])
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
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]).
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])