Get array from measure

Question

need to take array from other measure&nbsp;Measure =&nbsp;{"MU", "DU", "DS"}&nbsp;Measure2 =&nbsp;Var findVal = [Measure]RETURN...some code..FILTER ('Table1',NOT ('Table1'[ZU0_KOD] NOT IN findVal))

amitchandak · Answer

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 · Answer

it is not the same, and i didint get answer

amitchandak · Answer

Analitika , when what pass values from Measure. If typically test for some value like
&nbsp;
maxx(filter(values(Table[col]), not(isblank([measure])),[Measure2])
&nbsp;
Here non-blank value of the measure for col will pass. So what is the&nbsp; need in this case? Can you elaborate.

analitika · Answer

I have 100 measures likeMeasure =&nbsp;"MU" ' as static variable, so i can easy change in one place, rather change all 100 measures&nbsp;&nbsp;Measure2 =&nbsp;Var&nbsp;findVal&nbsp;= [Measure ]RETURN...some code..FILTER ('Table1',FIND ( findVal, 'Table1'[ZU0_KOD], , 0 ) = 0)&nbsp;Now i need to have multiple values, which will changes every weekSo i need something like that&nbsp;Measure =&nbsp;{"MU", "DU", "DS"}&nbsp;Measure2 =&nbsp;Var findVal = [Measure]RETURN...some code..FILTER ('Table1',NOT ('Table1'[ZU0_KOD] NOT IN findVal))

amitchandak · Answer

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.
&nbsp;

Forum Discussion

Get array from measure

10 Replies

Related content

array to filter

Power automate append to array function

Copy Activity: JSON Array Mapping

Create Array (List) with DAX

Measure