Forum Discussion

vipinkmathews's avatar
vipinkmathews
Icon for Advocate III rankAdvocate III
8 years ago
Solved

How 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 ...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

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

  • vipinkmathews's avatar
    vipinkmathews
    Icon for Advocate III rankAdvocate III
    8 years ago

    Thank you very much MFelix

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

      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