Forum Discussion

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Hyperlink DAX code

Hi all,

 

I'm trying to create a hyperlink for a report but when inputting the below DAX I receive an error saying the CandidateREf cannot be determined?

 

1.

 

 

Thanks,

 

Henry

Need Help

4 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi HenryJS 

    you are trying to create measure, not caculated column. measure requires some calculaion. try new column

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi HenryJS ,

     

    You are creating a Measure instead of a Calculated column, please modify the DAX to

    FORMAT(SELECTEDVALUE('table name'[column name]))

    Or please right-click on the table or any column of the table and select new column to create a Calculated Column.

    For more details about Measure and Calculated Column, please refer to the video below.

    https://www.youtube.com/watch?v=SVEGfqCTodc.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • HenryJS's avatar
      HenryJS
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      Hi,

       

      The calculated column now works and creates the desired hyperlink.

       

      How do I create a button and link to the hyperlink as per image 2? At the moment it is just displaying image 1.

       

      1.

       

       

       

      2.

       

      Thanks,

       

      Henry