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 anoth...
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