Same value for all months

[Sdhn420]

Hi,

How can I display same value for Average sales of 3 months measure for all the months?

Example: 

Measure - Average sale of 3 months = 300

Code   Month    Avg Sales   qty

M100   Jul          300            600

M100  Aug        300            200

M100  Sep         300            450

[Sdhn420]

@Greg_Deckler That kind of works. Its now showing same value across months but for all codes.

I have different material codes - 

Code   Month    Avg Sales   qty

M100   Jul          300            600

M100  Aug        300            200

M100  Sep         300            450

M200 Jul            400           200

M200 Aug         400           600

[Greg_Deckler]

@Sdhn420 - Use ALLEXCEPT instead of ALL to keep the material code filter.

[Sdhn420]

@Greg_Deckler @amitchandak used this calculate(average(Table[qty]), allexcept(Table, Table[Code])) but its giving different values for all the months. 

[v-jingzhang]

Hi @Sdhn420 I tested this measure and it worked well like below. Does your data come from the same table or from different tables? If they are in different tables, is there any relationship between them?

Regards,
Community Support Team _ Jing Zhang

[amitchandak]

@Sdhn420 , Try like

calculate(average(Table[qty]), allexcept(Table, Table[Code]))

[Sdhn420]

@amitchandak value is changing for each month 😞

[Greg_Deckler]

@Sdhn420 Perhaps try something like:

Average = AVERAGEX(ALL('Table'),[qty])