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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

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

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