Measures greyed out on field value for background conditional formatting

[Anonymous]

Hello, 

I have placed a card visual on my report page which I would like to be either white or transparent depending on filter selection

I have trialed the following 2 measures

first trial measure:

GEO Make Transparent =
if( ISFILTERED(TableA[Column A])
&& values(TableA[Column A]) = "Services",
"#FFFFFF00",
"White"
)

2nd trial Measure

GEO Make Transparent 2 =
if( ISFILTERED(TableA[Column A])
&& values(TableA[Column A]) = "Services",
"#FFFFFF00",
"#FFFFFF"
)

The measure works fine but when I try to conditionally format background colour on my card to use the measure  all my measures are greyed out and I cannot select any.

Any suggestions?
Thank you

[Fowmy]

@Anonymous 

Have you selected multiple values in the slicer? Set Single-Selection on for your slicer. 

Your measure looks fine

[Anonymous · Accepted solution]

I have resolved by issue. The measure was set to format decimal , I have since set it to text and it now allows me to select it. 

Thanks for viewing

[jaime_checa]

Ty!

[selimovd]

Hey @Anonymous ,

usually they are always gray.

Can you check if you can still click on them?

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

[Anonymous]

I cannot click/ select them.