Forum Discussion

gomezc73's avatar
gomezc73
Helper V
2 years ago
Solved

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. Currently in my measure i have a the SUMX with the following Filter: ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • gomezc73's avatar
    gomezc73
    Helper V
    2 years ago

    Worked perfect!!. thank you