Forum Discussion

trwatts's avatar
trwatts
Helper I
4 years ago
Solved

Has one value with a field parameter error

Hi everyone,    I am looking to use the hasonevalue and switch true to dynamically present some trend information using a field parameter.  The below is the error and dax I currently have.  Any h...
error
  • amitchandak's avatar
    amitchandak
    4 years ago

    trwatts , there is challenge when we directly check the value. I have used this code to check the selected value

    What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])

     

    Check if that is blank means , nothing selected 

     

    or try hasonevalue on order column

amitchandak's avatar
amitchandak
Super User
4 years ago

trwatts , there is challenge when we directly check the value. I have used this code to check the selected value

What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])

 

Check if that is blank means , nothing selected 

 

or try hasonevalue on order column

trwatts's avatar
trwatts
Helper I
4 years ago

Thanks amitchandak 
I have tried the order value in the hasonevalue section and havent had any luck. 
Not sure exactly where to drop the formula you gave into the dax?