Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |