Forum Discussion

PBIfanatic's avatar
PBIfanatic
Helper V
6 years ago
Solved

Same column, multiple filters

Hi, Is it possible to create multiple filters from the same column and use the input from both the filters to feed the chart. So its effectively the same column in the axis of the chart but the sele...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi PBIfanatic ,

    We can create a measure to meet your requirement.

    The measure calculate the sum total between [Slicer_value 1] and [Slicer_value 2].

     

    Slicervalue total = 
var _selected1 = VALUES('Slicer 1'[Group])
var _selected2 = VALUES('Slicer 2'[Group])
var _value1 = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected1))
var _value2 = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected2))
return
_value1 + _value2

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

PBIfanatic's avatar
PBIfanatic
Helper V
6 years ago

Thanks v-zhenbw-msft , thats awesome.

Its very close to what I need, is there a way to show the selected dimensions in the chart?

If I have a single selection from Slicer 1 and I select 3 from Slicer 2, is it possible to show all these 4 selections as separate lines in the chart?

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

Hi PBIfanatic ,

We can create a measure to meet your requirement.

The measure calculate the sum total between [Slicer_value 1] and [Slicer_value 2].

 

Slicervalue total = 
var _selected1 = VALUES('Slicer 1'[Group])
var _selected2 = VALUES('Slicer 2'[Group])
var _value1 = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected1))
var _value2 = CALCULATE(SUM('Table'[value]),FILTER('Table', 'Table'[Group] in _selected2))
return
_value1 + _value2

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ zhenbw

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

  • shrutik's avatar
    shrutik
    Frequent Visitor
    3 years ago

    Hey,I have multiple slicers from multiple columns.Can this work for the same?

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI, I have tried this approach and it worked, But
    When no values are selected , its actually shows double the actual output. 
    like return value1+value2. Could you please suggest someting for that.

    For slicer 1 and 2 i am using number values.