Forum Discussion

ssk_1984's avatar
ssk_1984
Helper II
2 years ago

Calculate column level average by multiple category

Hi Team,   help to add column to calculate average by multiple category. Here i want to calculate the Average of logged hours by adding new column for the criteria, Outliers should be no, group by...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

ssk_1984 

is this what you want?

Column = if('Table'[Outlier]="No",CALCULATE(AVERAGE('Table'[conloggedhrs]),ALLEXCEPT('Table','Table'[employeeid],'Table'[converted month]),'Table'[Outlier]="No"))