Forum Discussion

Analitika's avatar
Analitika
Post 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
Analitika's avatar
Analitika
Post Prodigy
6 years ago

I have 100 measures like

Measure = "MU" ' as static variable, so i can easy change in one place, rather change all 100 measures

 

 

Measure2 = 

Var findVal = [Measure ]
RETURN

...some code..

FILTER (
'Table1',
FIND ( findVal, 'Table1'[ZU0_KOD], , 0 ) = 0
)
 
Now i need to have multiple values, which will changes every week
So i need something like that
 

Measure = {"MU", "DU", "DS"}

 

Measure2 =

 

Var findVal = [Measure]

RETURN

...some code..
FILTER (
'Table1',
NOT ('Table1'[ZU0_KOD] NOT IN findVal)
)

amitchandak's avatar
amitchandak
Super 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.