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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
matemusic
Advocate III
Advocate III

Columne as multiple values in filter function (or other ways

Hey everyone.

 

Is there a way, to input column in filter function?

 

Here is an example:

 

var x = values(Here comes a calculated column filter by other measurement condition) 

return
calculate(sum(sales[price]);filter(sales;[product]=x)

So in var x i get list of product names which are filtered by other measure. In return i want to get all products, which are in var x. 

 

Thank you

1 ACCEPTED SOLUTION
v-ljerr-msft
Employee
Employee

Hi @matemusic,

 

As we can define variables with both scalar values and tables, you should be able to define an expression like the following one in your scenario.

[RedSales] :=
VAR RedProducts =
FILTER ( ALL ( Product[Color] ), Product[Color] = "Red" )
RETURN
CALCULATE ( SUM ( Sales[Quantity] ), RedProducts )

In addition, here is a good article about Variables in DAX for your reference.Smiley Happy

 

Regards

View solution in original post

2 REPLIES 2
v-ljerr-msft
Employee
Employee

Hi @matemusic,

 

As we can define variables with both scalar values and tables, you should be able to define an expression like the following one in your scenario.

[RedSales] :=
VAR RedProducts =
FILTER ( ALL ( Product[Color] ), Product[Color] = "Red" )
RETURN
CALCULATE ( SUM ( Sales[Quantity] ), RedProducts )

In addition, here is a good article about Variables in DAX for your reference.Smiley Happy

 

Regards

austinsense
Impactful Individual
Impactful Individual

Without ever having done it, I bet you can create a variable that returns a table and then pass that into your measure

 

 

var x = FILTER( VALUES(Products), [Measure])
RETURN
CALCULATE( SUM(Sales[Price]), x)

 

I'm not 100% sure if this is what you're asking for but let me know if it works 🙂

 

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.