Forum Discussion
Average excluding zero by item
need help with DAX and Filters... i think. My current formula is calculating on the entire table... i need it by row,
Anonymous You might try AVERAGEX(FILTER(ALLEXCEPT(...),[Daily Average]<>0),[Daily Average])
Nope... i probably have the syntax wrong
it is not iterating per row?
it helps if i have the right relationship set up!