Create a Data Table With a Specified Number of Rows

[lg1551]

I need to create a data table in DAX with a specified number of rows, based on the value found in a MAX measure that I have in my model. Any ideas?

I'm basically needing to generate a row for each value, 0 - (Whatever number is in the measure). I will then use these rows as columns in a bar chart to achieve a "hack" to the visual that I need.

The MAX MEASURE I have shouldn't contain a value of more than around 500-600 so the table I create wouldn't have any more rows than that.

[vicky_]

Number 0-600 = GENERATESERIES(0, 600) will get you a table with numbers 0-600. I do not recommend using your dax measure to specify the max number, as it won't actually update unless you refresh data - just generate more numbers than you need, and then use visual filters to limit the values displayed in your final visual.