Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filters out only one column using Slicer in the multiple column table

Hello Good morning, When I choose the option on slicer example: month slicer for month January  The table displays the column A, B, C, and D for the January month Instead, I am trying to achie...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Here's my solution.

    Sample data:

     

    1.Create a seperate table by creating a calculated table.

    Month = DISTINCT('Table'[Month])

     

    2.Create a measure to get the dynamic value by the slicer filtering.

    Dynamic A = CALCULATE(SUM('Table'[A]),FILTER('Table',[Month] in ALLSELECTED('Month'[Month])))

     

    3.The field in the slicer is from Month table. Here's the result.

     

    You can check more details from my attachment.

     

    Best Regards,

    Stephen Tao

     

    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
4 years ago

Hi Anonymous ,

 

Here's my solution.

Sample data:

 

1.Create a seperate table by creating a calculated table.

Month = DISTINCT('Table'[Month])

 

2.Create a measure to get the dynamic value by the slicer filtering.

Dynamic A = CALCULATE(SUM('Table'[A]),FILTER('Table',[Month] in ALLSELECTED('Month'[Month])))

 

3.The field in the slicer is from Month table. Here's the result.

 

You can check more details from my attachment.

 

Best Regards,

Stephen Tao

 

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