cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

CAN NOT CREATE MEASURE WITH DIRECT QUERY CONNECTION

HI ALL,  

I know direct query connection has a limitation, but l know you can create a measure using Direct query connection.   When l click on the new measure, l can name the measure, but everything is grayed out 

 

Ex Sales YTD = TOTALYTD([Internet Total Sales],   'Date'[Date])  

but cannot select either   [Internet Total Sales], or  'Date'[Date]) is grayed out.  

 

Please Help

2 REPLIES 2
edejes2
Advisor

Re: CAN NOT CREATE MEASURE WITH DIRECT QUERY CONNECTION

What it's your source of data on this direct query connection

 

Regards!

ED

Anonymous
Not applicable

Re: CAN NOT CREATE MEASURE WITH DIRECT QUERY CONNECTION

Hi ED

 

Thanks for replying source of data is sql server.

 

Thanks

PC