2 Replies Latest reply: Jun 28, 2017 12:48 PM by Carlos Daniel RSS

    Calculating line graph for all possible values of a dimension

    Carlos Daniel

      I have the following measure in a line graph where my dimension is M1. However the graph only shows values when M1 is selected, and i'd like the graph to show values for every value in M1. Below the formula is a table with some example data about the values in M1.

       

      (

      Sum({$<M={$(=MFe)}>}np*fe_m)

      +

      Sum({$<M={$(=MFeAnt)}>}np*fe_m_ant)

      +

      Sum({$<M={$(=MFeAnt2)}>}np*fe_m_ant2)

      )

      /

      (

      Sum({$<M={$(=MFe)}>}fe_m)

      +

      Sum({$<M={$(=MFeAnt)}>}fe_m_ant)

      +

      Sum({$<M={$(=MFeAnt2)}>}fe_m_ant2)

      )

       

      MM1MFeMFeAntMFeAnt2
      13321
      23321
      33321
      24432
      34432
      44432