Dax selected value not giving right result

[Mahmed1]

Hi

I have a parameter set up that allows me to put values from 1 to 1000

i have changed the parameter slicer to dropdown and greater than or equal to see if it works

all i am trying to do is do a simple calc that takes the total score and deducts the parameter value 

but the result is either showing blank

so my first question is hoe doni retrieve the value of the parameter selected value?

i have tried this simple formula

MyScore = [Total_Score] - Parameter(Parameter_Value] with no luck at all

[Mahmed1]

Hi @Fowmy 

nothing seems to work with the parameter value

either 0 or 1m is returned no matter how i change slicer

ive tried different variations 

please see snapshots of what ive tried

 

 

 

 

 

[Fowmy]

@Mahmed1 

First you need to set the Style to Single Value if you need to get the selectedvalue. 

[Mahmed1]

Hi 

i dont see that option unfortunately- thats what im looking for

am i missing something 

[Fowmy]

@Mahmed1 

Make sure you crated the Parameter using the option as follows, otherwise, you will not get that Single Value option:

[Mahmed1]

@Fowmy 

hi i managed to figure the issue

it was because i entered into a slicer rather than the parameter slicer

My set up is on a normal slicer which dont have the single value option

Is there anyway at all i can retrieve the value that is input in to the great >= box (my slicer is the greater than or = to option)

[Mahmed1]

Hey that's exactly what i did using numeric

min value = 1

max value = 1000000

increment = 1

default = 1

added slicer

but when i go to change slicer

i get every option like tile, dropdown, between, greater than etc but not the single value selection which is weird

[Mahmed1]

hey ill give this a go

does of the paramater is a greater than or equal to slicer which can be between 1 and 10000

will this still work as max potential value is 10000 not the actual value?

[Fowmy]

@Mahmed1 

You can get the minimum value using

MIN( Parameter(Parameter_Value] )

[Fowmy]

@Mahmed1 

Try this :

MyScore = [Total_Score] - MAX( Parameter(Parameter_Value] )