A measure use dynamic array value

[longyu68]

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:

[Anonymous]

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]

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]

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