Forum Discussion

longyu68's avatar
longyu68
Regular Visitor
8 years ago

A measure use dynamic array value

Help!

 

I create a measue to calculate the number of open opportunities for selected RUs. The measure works fine if the array value is hard coded (refer to below snap)

 

then I create another measure to show the dynamic array value, which works fine as well: 

 

When I use the second measure in the first measure, nothing return. Any help would appreciated:

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi longyu68,

     

    I'd like to suggest you use ALLSELECTED ( T1_Bu_Ru[Ru] ) to replace {[Run_list]} part.

    Notice: RU_List measure return string value, it can't works as text list.

     

    Regards,

    Xiaoxin Sheng

    • longyu68's avatar
      longyu68
      Regular Visitor
      8 years ago

      Thanks Sheng

       

      ALLSELECTED ( T1_Bu_Ru[Ru] ) doesn't work for me. There is no relationship between T1_Bu_Ru[Ru] and [DefaultRU]. While PowerBI prevent me creating a relationship between them due to the fact that [DefaultRU] is build based on a formula. 

       

      I will re-construct my data and seek a way of building the relationship first.

       

      Thanks for your help again. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI longyu68,

         

        If you can please share some sample data for test.

        BTW, I dont think you can direct get filtered value from unrelated tables.

         

        Regards,

        Xiaoxin Sheng