Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

DAX Calculate help

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

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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? :smileyhappy:

     

    Regards

  • mattbrice's avatar
    mattbrice
    Icon for Solution Sage rankSolution Sage
    9 years ago

    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.