topic Average excluding zero by item in DAX Commands and Tips

Average excluding zero by item

Anonymous — Thu, 18 Aug 2022 16:48:49 GMT

need help with DAX and Filters... i think. My current formula is calculating on the entire table... i need it by row,

Greg_Deckler — Thu, 18 Aug 2022 16:55:42 GMT

Anonymous You might try AVERAGEX(FILTER(ALLEXCEPT(...),[Daily Average]<>0),[Daily Average])

Anonymous — Thu, 18 Aug 2022 17:38:34 GMT

Nope... i probably have the syntax wrong

Anonymous — Thu, 18 Aug 2022 18:44:48 GMT

it is not iterating per row?

Anonymous — Thu, 18 Aug 2022 20:06:51 GMT

it helps if i have the right relationship set up!