Forum Discussion
Generating Points based on an equation
You could do the majority of the work with a single measure. Create that equation as a measure and plot it onto a graph as the "Value". By providing the Projects in the legend, you will get a graph. You need another Axis, which is your described Xnum.
To make that work, create a table that simply has the XNums you wish to iterate over. It could be a simple 1 column table of values from 1 to whatever. Join that table to your other tables and use that xNum column as your axis.
But the problem is, the single measure would use Xnum in the formula. How do I accomplish that?
Thats where using the table of XNum values and placing it as an Axis on the graph produces those results. Measures are recalculated for each context. In this case, by using the Axis, you are creating a context for each and every XNum.