cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Highlighted
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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 219 members 2,771 guests
Please welcome our newest community members: