Forum Discussion

Sdhn420's avatar
Sdhn420
Icon for Helper IV rankHelper IV
5 years ago

Same value for all months

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   J...
Need Help
Sdhn420's avatar
Sdhn420
Icon for Helper IV rankHelper IV
5 years ago

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

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

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