Show custom message when tables are linked but selected value not found

[NJ_hokie]

When you select a value in a slicer, if that value is not found in the linked table, how do you show a message (e.g. 'value not found'), instead of it just being blank?

Attached image shows all. Table names at top (tblName and tblTestScore). Linked by NameID field. Part a) shows it correctly showing the two score values for NameID 1. But if NameID 3 is selected I'd want to indicate that there are no values, not just show a blank table as currently shown. 

Thanks for any help. 

[ryan_mayu · Accepted solution]

@NJ_hokie 

there is a workaround for you. You can create a card beside the table

comments = if (ISBLANK(max(TestScore[Score])),"no value","")

pls see the attachment below

[speedramps]

Hi @NJ_hokie 

Thanks for accepting a solution.

Please can you also accept mine.

You cam accept more than one solution to show you appreciation to helpers.
It was one of the first and works ok.

The [accept solution] points help reflect my competency and your gratitude.

Thank you for your assistance in the matter

[NJ_hokie]

I accepted both solutions, which included yours, immediately after my earlier reply. I no longer see an 'accept as solution' after what you wrote, so as far as I can tell I did accept it. I'm new to this forum so if there is something I did not do correctly let me know and I will correct it. 

[NJ_hokie]

Both of these solutions help and answer my question in various ways, thanks!

[speedramps · Accepted solution]

Hi @NJ_hokie 

@ryan_mayu  has suggested a good idea but it does not work if you select more than one name

Try this method ...

Right click on Name and select Show items with no data

another way is create measure with + 0.

This will always force a value, even when there is nothing

Answer = 
SUM(Scores[Score]) + 0

 

Please click thumbs up and accept solution. You can accept more than one solution. Thank you !

[NJ_hokie]

Thanks @ryan_mayu, this is generally getting toward what I need, I just need the info in the table itself. If adding your comments measure to the table as shown in this image, what I think or hope should happen is it only shows nameID 3, with an actual blank for score and 'no value' under comments. The other nameIDs would not be displayed unlike shown. 

[ryan_mayu · Accepted solution]

@NJ_hokie 

there is a workaround for you. You can create a card beside the table

comments = if (ISBLANK(max(TestScore[Score])),"no value","")

pls see the attachment below