Forum Discussion

lg1551's avatar
lg1551
Resolver II
3 years ago

Create a Data Table With a Specified Number of Rows

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.

Need Help

1 Reply

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago
    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.