Forum Discussion

homboy27's avatar
homboy27
Helper III
1 year ago
Solved

Selecting Individual Prompt Options in Advance Editor

Please see above prompt I am entering in advance editor. I would only like to bring in ABC00001-01 and ABC00004-01. However the above is only bringing in ABC00001-01. How do I bring in just ABC...
Need Help
Show and Tell
Tips and Tricks
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi @homboy27,

     

    We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
    If my response resolved your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi homboy27,

 

Thank you for reaching out to Microsoft Fabric Community.

 

The issue here likely is that operator 4 applies a range filter, not a list. That includes all values between ABC00001-01 and ABC00004-01 like depending on what exists in the model and how it is sorted.

So to include only specific values, use operator 6 which means set inclusion, like this below:


{Cube.ApplyParameter, "VAR_NHS_LEVEL1", {6, "ABC00001-01", "ABC00004-01"}}

This ensures only those two values are included, the cube will fetch exactly the values and ignore anything in between.

 

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa

homboy27's avatar
homboy27
Helper III
1 year ago

4 is equals to and 6 is between. When I try that with 4. It doesnt works. 

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi homboy27,

     

    The issue here is like we can see one value is because the operator 4 means Equals, which supports only one value. When you pass two values only the first one is applied the rest are ignored. Cube parameters like ApplyParameter do not support multi value with Equals filters directly.

    Try to use this below one, filter after the cube is loaded by using power query:

    Table.SelectRows(Source, each [VAR_NHS_LEVEL1] = "ABC00001-01" or [VAR_NHS_LEVEL1] = "ABC00004-01")

    This will ensure only the two values are returned.

     

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi homboy27,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
      If my response resolved your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        1 year ago

        Hi @homboy27,

         

        We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
        If my response resolved your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

         

        Thanks and regards,

        Anjan Kumar Chippa