what if parameter giving me an aggregation error

[Anonymous]

I have a column called duration. I want to create a dynamic what if parameter that a user can change.

Duration column

5’

10’

20

8’

….

If the parameter is set to 10’ and up then its “greater than parameter” or “less than parameter”

i.e.

5 less

10 less

20 greater

8 less

I created a parameter like this:

Then I create a new column:

With my function lookling like this:

lower_or_greater = IF(Parameter[Parameter Value] < 'individual lines csv'[Duration],"Smaller Parameter" , "Greater Parameter")

So this gets me the values Smaller/Greater Parameter like this:

But the problem that im currently having is that, even when I change the slider, it still is defaulted to the 500 default that I had set earlier:

Even with the slider that i put on there, it will not change the location"

Can someone tell me what im doing incorrectly perhaps.
my columns look like this:

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see attachment), please check whether that is what you want.

Create a measure as below to replace your original calculated column [lower_or_greater]:

Best Regards

[Greg_Deckler]

@Anonymous Columns are not dynamic based on user input, they are calculated once when created and only recalculated during data refresh.

[Anonymous]

okay. So to have that feature, i made it into a measure with this: 

Now that I have that new measure, i want to bucket the 1's and 0's into a 100% stacked column chart. What can i do after doing this? 

or do you see what im trying to accomplish and do you have any other alternatives to what im trying to do ? 

[Greg_Deckler]

@Anonymous In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563

[Anonymous]

does that work for what if parameters. and what did you mean by data refresh by any chance ?