Forum Discussion

trwatts's avatar
trwatts
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper I rankHelper I
4 years ago

Worked it out. 
Thank you for your help it is greatly appreciated. 🙂