topic Re: Data Measure in DAX Commands and Tips

Data Measure

Anonymous — Mon, 28 Dec 2020 16:42:33 GMT

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")

Re: Data Measure

amitchandak — Mon, 28 Dec 2020 16:53:43 GMT

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/

Re: Data Measure

Anonymous — Wed, 30 Dec 2020 07:32:13 GMT

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?

Re: Data Measure

Anonymous — Wed, 30 Dec 2020 07:35:05 GMT

Ok, i was to fast, sorry!!!

The solution ist "isfiltered"