Forum Discussion

Cary_Casey's avatar
Cary_Casey
Frequent Visitor
6 years ago
Solved

Total Average - Monthly Average

Hello,   I'm attempting to show a difference between average product over all history minus the monthly sum product. The problem is getting a measure that ignores the dates and just takes an aggreg...
Need Help
  • VasTg's avatar
    VasTg
    6 years ago

    Cary_Casey 

     

    Try this..

     

    Average Monthly Quantity=CALCULATE((SUM(table[product_quantity])/DISTINCTCOUNT('table'[YearMonth])),ALL(table))

     

     

    If it helps, mark it as a solution

    Kudos are nice too 

Cary_Casey's avatar
Cary_Casey
Frequent Visitor
6 years ago

VasTg Thank you!

 

It does indeed include all dates! I appreciate your prompt response. I was really not wrapping my head around it clearly!

 

Edit: Changed the code to AllExcept so that I could use the slicers that apply to this data!