I have this Tableau function {fixed [PRMRY_KEY]: AVG([EST_RESOURCE_HOURS])} In need to convert this function in to Dax.
Thanks in advance.
maybe you can try allexcept
ALLEXCEPT function (DAX) - DAX | Microsoft Docs
=calculate(average[EST_RESOURCE_HOURS],allexcept(table,[prmry_key])
Proud to be a Super User!
User | Count |
---|---|
136 | |
88 | |
65 | |
59 | |
57 |
User | Count |
---|---|
213 | |
108 | |
86 | |
82 | |
76 |