Tableau's Fixed Function with Avg

[Usman6400]

I have this Tableau function {fixed [PRMRY_KEY]: AVG([EST_RESOURCE_HOURS])} In need to convert this function in to Dax.

Thanks in advance.

[ryan_mayu]

@Usman6400 

maybe you can try allexcept

ALLEXCEPT function (DAX) - DAX | Microsoft Docs

=calculate(average[EST_RESOURCE_HOURS],allexcept(table,[prmry_key])