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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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