Same value for all months

Question

Hi,&nbsp;How can I display same value for Average sales of 3 months measure for all the months?&nbsp;Example:&nbsp;&nbsp;Measure - Average sale of 3 months = 300&nbsp;Code&nbsp; &nbsp;Month&nbsp; &nbsp; Avg Sales&nbsp; &nbsp;qtyM100&nbsp; &nbsp;Jul&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 600M100&nbsp; Aug&nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200M100&nbsp; Sep&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 450

greg_deckler · Answer

Sdhn420&nbsp;Perhaps try something like:
Average = AVERAGEX(ALL('Table'),[qty])

sdhn420 · Answer

Greg_Deckler&nbsp;That kind of works. Its now showing same value across months but for all codes.&nbsp;I have different material codes -&nbsp;&nbsp;Code&nbsp; &nbsp;Month&nbsp; &nbsp; Avg Sales&nbsp; &nbsp;qtyM100&nbsp; &nbsp;Jul&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 600M100&nbsp; Aug&nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200M100&nbsp; Sep&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 450M200 Jul&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200M200 Aug&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600

amitchandak · Answer

Sdhn420 , Try like
calculate(average(Table[qty]), allexcept(Table, Table[Code]))

sdhn420 · Answer

amitchandak&nbsp;value is changing for each month 😞

greg_deckler · Answer

Sdhn420&nbsp;- Use ALLEXCEPT instead of ALL to keep the material code filter.

Forum Discussion

Same value for all months

7 Replies

Related content

Month over Month with multiple text values

Month to Month Flow Calculation

Rolling values for 3 months

Latest Month value

Value 12 Months Ago