Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Analitika
Post Prodigy
Post Prodigy

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

10 REPLIES 10
Dwesty_A
Frequent Visitor

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
Super User
Super User

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

it is not the same, and i didint get answer

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

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

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

 

Hi @Analitika ,

 

Try to do like this.

v-lionel-msft_0-1597990475297.png

 

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.

 

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

Hi @Analitika ,

 

v-lionel-msft_0-1598336039373.png

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.