Forum Discussion
Advocate IIIHow to create measure in Direct Queries
Hi
I tried to create running total & variance on direct query dataset which is not possible.
Is there any alternative to create running total or measures using direct query?
Regards
Vipin
Hi vipinkmathews,
You need to go to:
File > Options and then Settings > Options and settings > DirectQuery, then selecting the option *Allow unrestricted measures in DirectQuery mode**.
Just look at this link to see the vantages/ disavantages and options you have with direct query.
Regards,
MFelix
Thank you very much MFelix
5 Replies
- MFelix
Super User
Hi vipinkmathews,
You need to go to:
File > Options and then Settings > Options and settings > DirectQuery, then selecting the option *Allow unrestricted measures in DirectQuery mode**.
Just look at this link to see the vantages/ disavantages and options you have with direct query.
Regards,
MFelix
vipinkmathewsThank you very much MFelix
v-ljerr-msftMicrosoft Employee
Hi vipinkmathews,
Do you still have any question on this issue? If not, could you accept the reply from MFelix as solution to close this thread? :smileyhappy:
Regards
- MFelix
Hi Rhyndra ,
You are correct that the option for the Unresctrited Measure is no longer available, with the introduction of composite models (July 2018), this "unrestricted measures" is implicitly on. Since there is nothing to choose, they removed the checkbox from the options dialogue due to the composite models.
So currently this is active by default, so you can make measures on direct query.
Regards
MFelix
