DAX MEASURE HELP - Calculate using two filters

[Anonymous]

Hi,

I am trying to say if an adnumber has bothe a digital and print then +1

table looks like

10009 INET Advertiser

10009 NEWS Advertiser

10000 Inet Advertiser

10002 Inet Advertiser

So for example it would return 1.  

My dax code is

Print with Digital = CALCULATE(count(insertBK[adnumbr]),titles[mediatype]="INET" && titles[mediatype]="NEWS", userDefs[adoper] <> "BA430" 
&& userDefs[adoper] <> "CA148" 
&& userDefs[adoper] <> "HX355" && userDefs[adoper] <> "MD301")

It only seems to evaluate INET,

Thanks

[spuder · Accepted solution]

Hi @Anonymous,

in my opinion titles[mediatype] cannot be "INET" AND "NEWS" use OR instead.

In this case change && -> ||

[Anonymous]

Thanks Spuder, will give that a try.

Chris