Data Measure

[Anonymous]

Hello,

do one have one an idea.... i calculate backgroud color, dependig on "selected valuse".

Do one have an idea how to calculate it by DATA? 
Excepct, when not "all" than change color.




Here an expamle for anonther measurement

Debitor = IF(SELECTEDVALUE(Sheet1[Debitor]) <> "", "#FF8C00", "#85b8cb")

[amitchandak · Accepted solution]

@Anonymous , You have use isfiltered

Debitor = IF(isfiltered(Sheet1[Debitor]) , "#FF8C00", "#85b8cb")

Refer: https://www.youtube.com/watch?v=hXg3kRFSGjA

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Anonymous]

Well thank you at first... your sulution is pretty cool but the solution i´m using works also.

But this wasn´t the hint for my problem.
Does ony one know the solution in my case?

[Anonymous]

Ok, i was to fast, sorry!!!

The solution ist "isfiltered"