Get array from measure

[Analitika]

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

[Dwesty_A]

Have you get the answer? I have the same problem like you.  I must make Venn Diagram, but exact value not return unique value.

[amitchandak]

@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]

it is not the same, and i didint get answer

[amitchandak]

@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]

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]

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

[Analitika]

---

@amitchandak wrote:

@Analitika , This is an interesting use case. And I can only say suggest something after I solve it....

---

https://easyupload.io/0xbpvt

[v-lionel-msft]

Hi @Analitika ,

Try to do like this.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Analitika]

TY, i already did like this, but i need get this array TO variable from other Measure

[v-lionel-msft]

Hi @Analitika ,

But the measure does not support this grammatical structure.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.