Forum Discussion

SteveIOW's avatar
SteveIOW
Helper II
4 years ago

error when more than one value

Hello,   I have a card I am using to change a title for a summary page depending on the 'Modality' chosen. Shown below. My problem is that users may want to filter to the 'Big 7' before going to i...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey SteveIOW ,

 

VALUES returns a list of values. For that reason there is the error.

You could use MIN or MAX to get a single value or you can combine the VALUES with the CONCATENATEX function.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

  • SteveIOW's avatar
    SteveIOW
    Helper II
    4 years ago

    Thanks selimovd 

    I had sort of worked that out - although thanks for confirming.

    I don't quite understad how to do either of you suggestions though. Min/Max requires a table and although I thought Values created a table it seems I can't use it?

     

    thanks for taking your time over this.

    Steve