Forum Discussion

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

Super User

6 years ago

Analitika , you asked a similar question about the same. what is the object here?

in Dax better to return a table

https://docs.microsoft.com/en-us/dax/datatable-function

Var can be a list, measure needs to be a value.

Analitika
Post Prodigy
6 years ago
it is not the same, and i didint get answer
- amitchandak
  Super User
  6 years ago
  Analitika , when what pass values from Measure. If typically test for some value like
  
  maxx(filter(values(Table[col]), not(isblank([measure])),[Measure2])
  
  Here non-blank value of the measure for col will pass. So what is the need in this case? Can you elaborate.
  - 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)
    )

Related content