IF statement to show one value or blank - HELP

[MAJackson]

Hello,

I am creating a dashboard that shows a list of items on the left.   When an item is selected (filtered to 1) I would like the data to be displayed on the right.  I have mulitple fields and by default I would like everything blank until a single item is selected from the table. 

Is there a way to have a visual blank "  " until a single item is selected?

I tried the following if statement but am getting an error:

 View Company = IF(DISTINCTCOUNT (Engagements[Company]) = 1, Engagements [Company], "   ")

The text in red is not able to associate with the table/column I need.  When I enter text into that spot the formula works.  It reads the table/column correct in the distinct count section but not the if value is true display company  section.

Any help would be greatly appreciated. 

[v-lid-msft]

Hi @MAJackson ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @MAJackson ,

We can try to create a measure to meet your requirement:

Measure = IF(HASONEVALUE(Engagements[Company]),VALUES(Engagements[Company]),BLANK())

Best regards,

[Tahreem24]

You can use below accepted solution using below link:
https://community.powerbi.com/t5/Desktop/Text-field-to-show-the-selected-filter/td-p/251023

Don't forget to give thumbs up 👍and accept this as a solution if this helps you.

[Tahreem24]

You can use isfiltered DAX function.
https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

Don't forget to give thumbs up 👍and accept this as a solution if this helps you.