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)
)
| M | M1 | MFe | MFeAnt | MFeAnt2 |
|---|
| 1 | 3 | 3 | 2 | 1 |
| 2 | 3 | 3 | 2 | 1 |
| 3 | 3 | 3 | 2 | 1 |
| 2 | 4 | 4 | 3 | 2 |
| 3 | 4 | 4 | 3 | 2 |
| 4 | 4 | 4 | 3 | 2 |
