Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 years ago

Get array from measure

need to take array from other measure   Measure = {"MU", "DU", "DS"}   Measure2 =   Var findVal = [Measure] RETURN ...some code.. FILTER ( 'Table1', NOT ('Table1'[ZU0_KOD] NOT IN findVal) ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Analitika , This is an interesting use case. And I can only say suggest something after I solve it. Would it possible to share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Analitika ,

     

    Try to do like this.

     

    Best regards,
    Lionel Chen

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

     

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      TY, i already did like this, but i need get this array TO variable from other Measure

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Analitika ,

         

        But the measure does not support this grammatical structure.

         

        Best regards,
        Lionel Chen

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