Selectedvalue in calculated column to generate numeric ranges

[Smackcat]

Hi experts! I ideally would like an user inputbox, but as it's not available on PowerBI, I'm using an slicer for the user to select a unique value. With this selected value, I would like to create numeric ranges.

I have an "Income" column. I want the user to select a "Number", with this number I want to create ranges "From XX to YY" according to the selected value on "Number" (the range is constructed from multiples of "Number": "From 1 to 29", "From 30 to 59", and so on...).

To get this "Number" value I have created on another table a list of numbers to get an slicer that allows the user to select a unique value. I had no issue at creating this sequential table (that's not my question)

I want to connect this unique selected value from the slicer to the "Number" column, but I think it's impossible to use SELECTEDVALUE on a calculated column, because the result is a blank column:

So my question is: is there a way I can create numeric ranges according to an user selected value on this slicer? is this even possible? is there a meassure at least I can use to get these numeric ranges? 

Thanks

[Smackcat · Accepted solution]

I found this article in order to create numeric ranges/banding/groupping on selectedvalue. It was really helpful: https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...

[mariussve1]

Hi,

If I understand you correct, could you use this:

https://dax.guide/generateseries/

Or maybe you should look into what if parameters. Then its possible for end user with input int values.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

Br

Marius

[Smackcat]

Hi @mariussve1 . I have updated my question with more clear information. I had no problem at creating a sequential table for the slicer. My question is if there is a way to create numeric ranges on a calculated column or measure from a number from this same slicer? (on a different table or on a what if parameter)