Forum Discussion

Carmichael's avatar
Carmichael
Advocate III
5 years ago
Solved

Best method to accept data from end user

Hi - simple scenario. I need the user to be able to enter a number in as a parameter for site size. This could be any whole number but let's say it's between the range of 1 to 1,000,000 sqft.   Wha...
General Comment
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    If you generate a table with this dax

    Table = GENERATESERIES(1,1000000,1)

    You can add that field to a slicer, set the slicer to be 'Greater than or equal to'.  This will give you a single field where the user can input thier number.  You can read that selection with a measure like this.

    Selection = MIN ('Table'[Value] )

    I have attached my sample file for you to look at.  Does that accomplish what you were looking for?

     

jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

If you generate a table with this dax

Table = GENERATESERIES(1,1000000,1)

You can add that field to a slicer, set the slicer to be 'Greater than or equal to'.  This will give you a single field where the user can input thier number.  You can read that selection with a measure like this.

Selection = MIN ('Table'[Value] )

I have attached my sample file for you to look at.  Does that accomplish what you were looking for?

 

Carmichael's avatar
Carmichael
Advocate III
5 years ago

jdbuchanan71  - I dont undersand how this works now.  This is exactly what I did previously but the number inputs were jumping around as well due to 'what I thought' was sampling of the data. 

But it works and is exactly what I need... so thank you!

EDIT: I do now see what I was doing.  I was selecting single value which still does round to a sampled value.  This is an awesome little work around.  I really hope others that have the same problem find this post!