4 Replies Latest reply on Sep 4, 2018 8:34 AM by Philipp Coenen

    calculate average across different measures

    Philipp Coenen

      Hello

       

      I'm looking to solve the following issue.

       

      What: I need to calculate the average per product across a number of measures, Here Stock level1 ....5

       

      MaterialClassificationStock level 1Stock level 2Stock level 3Stock level 4Stock level 5Average
      2850A003602248118
      2853A5.2591.6197.1306791.3993.217
      2859A4681.022581441119526
      2862B000000
      2863B5.1972.7581.6514.5755.4543.927
      2864B4.0151.6122.9642.4094.2893.058
      2868C403250480242426360
      2869C504042263238
      2870C002504314

       

      The problem: Since the data I want to average is located in different measures I cannot simply use AVG ( [MEASURE]).

       

      What I tried: I tried  {FIXED [ Product ] : Sum (Sum ([measure1], Sum ([measure2])....)}/ number of measures wich doesn't seem to work here.

       

      How do i need to approach this ?

       

      Best regards and thanks a lot in advance,

      Philipp