Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unable to create Parameter

While fetching data from SSAS, Unable to create Parameter.  New parameter option is disable.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Live connections?

    A live connection has some limitations

    Last 8 weeks = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]>=max('Date'[Week Rank])-8 && 'Date'[Week Rank]<=max('Date'[Week Rank])))

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      How can I make it as dynamic. 

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    Unfortunately, it is unsupported to use parameter when connect live to SSAS currently. If you use connect live, there's no query defined and no data imported, and the entire external model is shown in the field list. There are some limitations and considerations for live connection. For further information, please refer to the document .

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.