Forum Discussion

dc189's avatar
dc189
Icon for Helper II rankHelper II
9 years ago

Checking allow unrestricted measures in direct query does not work

Hello,

 

I am again facing a similar problem in a direct query model. Please see screenshot below. I have checked the "allow unrestricted measures" option but DAX is still not accepting the Calculate function. What's surprising is, DAX accepted the same Calculate function in a different table, but in this table, it is not. I tried using this formula both as a new measure and as a new column, but none worked. In a new measure, it does not accept the Earlier function and in a new column it does not accept any of the redlined functions shown below. Please help as this discrepancy is a big hurdle in an important assignment I'm on. Thank you, dc189.

 

 

Tips and Tricks

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi dc189,

     

    Based on my test, CALCULATE() function doesn't support in calculated column in DirectQuery mode, but it's available in a measure. In your scenario, as you are creating a calculated column instead of measure, just as the error message said, it's not supported.

     

    Best Regards,
    Qiuyun Yu

    • dc189's avatar
      dc189
      Icon for Helper II rankHelper II
      9 years ago

      Hi v-qiuyu-msft,

       

      Thanks for your reply. The reason I'm using a new column and not new measure is I need an image URL for each product category and URLs are not measures. My direct query formula looks like = IF(Category = "Boots", <Boots Image URL>, if(...)). I'm doing this for about 20 product categories.

       

      Unfortunately, direct query does not accept IF statements for columns.

       

      Do you know a way out of this?

       

      Thanks,

      dc189