Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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,

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

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

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Nope... i probably have the syntax wrong

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        it is not iterating per row?