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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
gomezc73
Helper IV
Helper IV

how filter the data based in 1 filter with multiple selection

Hi experts,

 

I have the following  slicer to select only 1 month, but now the users wants to select 1 or MORE months.

gomezc73_0-1698050961710.png

Currently in my measure i have a the SUMX with the following Filter:

Filter(Sales,Sales[Year_Month] = selectedvalue('Year_Month From'[Year_Month]).
 
It worked perfect with only 1 month selected. but when i select two or more months it doesn't work.
 
Can you please help me to understand how i must change that the filter to allow the SUMX work with several months selected?.. 
 
I really appreciate your help.

 

 

1 ACCEPTED SOLUTION
v-tianyich-msft
Community Support
Community Support

Hi @gomezc73 ,

 

You may try the following expression

 

Filter(Sales,Sales[Year_Month] in values('Year_Month From'[Year_Month])
 
Filter(Sales,Sales[Year_Month] in values('Year_Month To'[Year_Month])
 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

View solution in original post

4 REPLIES 4
v-tianyich-msft
Community Support
Community Support

Hi @gomezc73 ,

 

You may try the following expression

 

Filter(Sales,Sales[Year_Month] in values('Year_Month From'[Year_Month])
 
Filter(Sales,Sales[Year_Month] in values('Year_Month To'[Year_Month])
 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

Worked perfect!!. thank you

v-tianyich-msft
Community Support
Community Support

Hi @gomezc73 ,

 

The filter in DAX is selecting on the context, not filtering on the table data, I created simple samples to illustrate this for you:

vtianyichmsft_0-1698137329571.png

 

vtianyichmsft_1-1698137329574.png

 

Filter A = CALCULATE(SUMX('Sales','Sales'[Sales]),FILTER('Sales','Sales'[Type]="A"))

Total = SUMX('Sales','Sales'[Sales])

 

 

For one , It filters out sums of type A , for another , it doe not have any filters. And your goal is to filter the entire table dynamically based on time, not to filter the data in the table. So you can use the simple SUMX function to do just that.

 

Please feel free to correct me and provide more information if I have misunderstood you!

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

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

Hi, thank you for your early response.

 

I need explain how my reports works, because it is more complicated.

 

I have a file of SALES/products by months, and the original request is compare sales in diferent months.

 

To do that, i created two tables with the following comand:

 

Year_Month From = VALUES(Sales[Year_Month])
Year_Month To = VALUES(Sales[Year_Month])
 
 And i have a Slicer for each one
 
The first table has a ACTIVE relationship with the SALES files and the second file has a INACTIVE relationshionship .
 
To get the First of the first month i use a filter like this
Filter(Sales,Sales[Year_Month] = selectedvalue('Year_Month From'[Year_Month])
 
For the second month is use the same SUMX, but using a USERELATIONSHIP,
 
Filter(Sales,Sales[Year_Month] = selectedvalue('Year_Month To'[Year_Month])
 
In your response you use the Month from the same file SALES, but I can use it directly because i need compare two months.
 
it works fine selecting only 1 month in each slicer.
 
The issue is due the user wants select by example: Jan+Feb+Mar of 2022 in the first Slicer and compare it with Jan+Feb+Mar of 2023 (in the second Slicer)
 
In that case my Measure doesn't work and i don't know how it can be modified to allow multiple selections.
 
I really appreciate your help..
 
regards

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.