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 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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Sdhn420 , Try like

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

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


      amitchandak value is changing for each month 😞

  • 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