Create a default measure with no selection when no blank is in the field name.

[Thackeb]

I want a default message on a card when a slicer option is not selected.

If my field name has a blank as an option, I can use this successfully:

Default Sales Role Code Segment =

IF(ISFILTERED(Customer[Sales Role Code]),

FIRSTNONBLANK(Customer[Sales Role Code],Customer[Sales Role Code]),

"None Selected")

If my field doesn't have a blank as an option, the above shows the first name.  

Example of field options: 

Sales Role Code = blank, ENT, STA, SMB

Channel Name = Carton, FoodService,VMG

I'm struggling to rewrite the above measure with no success. Any help is greatly appreaciated. (Please note that I cannot create calculated columns as my tables are read only. This inhibits some Dax creation.)

[parry2k]

@Thackeb it is a measure.

[parry2k · Accepted solution]

@Thackeb not sure why you are doing FIRSTNONBLANK

Test = SELECTEDVALUE ( Customer[Sales Role Code], "None Selected" )

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Thackeb]

Thank you! Yes, I made this much more difficult. You are awesome!