DAX Calculate help

[Anonymous]

Hi,

I am wanting to use the following DAX code to retreive Values based on INET titles.

However it is returning nothing... Have I formulated the DAX correctly?

Thanks.

PrintDigital = CALCULATE([NoOfAds],titles[mediatype]="INET",userDefs[adoper] <> "BA430" 
&& userDefs[adoper] <> "CA148" 
&& userDefs[adoper] <> "HX355" && userDefs[adoper] <> "MD301", titles[ttlcode] = "WCNE" && titles[ttlcode] = "WHEX" && titles[ttlcode] = "WNST" && titles[ttlcode] = "WNWE" && titles[ttlcode] = "WTST" && titles[ttlcode] = "WWHA" )

[mattbrice]

First comment is if you use the "IN" operator, code is a bit easier to read:

PrintDigital =
CALCULATE (
    [NoOfAds],
    titles[mediatype] = "INET",
    NOT ( userDefs[adoper] IN { "BA430", "CA148", "HX355", "MD301" } ),
    titles[ttlcode] IN { "WCNE", "WHEX", "WNST", "WNWE", "WTST", "WWHA" }
)

Second comment is keep in mind the individual setfilter arguments to CALCULATE  are "AND" together.  Your filters together read Return [NoOfAd] where mediatype = INET and adoper not one of the values listed and ttlcode is one of the values you listed.  If all need to be true, you may be filtering out all the values in table.

[v-ljerr-msft]

Hi @Anonymous,

Are you using the formula to create a measure or calculate column?

Is there any relationship between your "titles" table and "userDefs" table? What's the formula of measure[NoOfAds]?

Could you post your table structures with some sample data and your expected result, so that we can better assist on this issue? 

Regards