Filter slicer Based on other Slicer value

Hey ahmadibrahimbus ,

Yes, you can achieve this by using a combination of measures, buttons, and slicers in Power BI. Here are the steps you can follow:

1. Create a table that contains your three measures and the other columns that you need for filtering.

2. Create two measures to calculate the value of your two measures that you want to show when multiple values are selected in the second slicer. You can use an IF statement to check the number of selected values in the second slicer and calculate the values accordingly.

For example, if you have three measures called Measure1, Measure2, and Measure3, you can create the following two measures:
Measure2ToShow = IF(COUNTROWS(VALUES(Table2[SecondSlicerColumn])) > 1, [Measure2] + [Measure3], [Measure2])

Measure3ToShow = IF(COUNTROWS(VALUES(Table2[SecondSlicerColumn])) > 1, BLANK(), [Measure3])

The first measure will show the sum of Measure2 and Measure3 when more than one value is selected in the second slicer, and the second measure will show a blank value.

3. Create a button that changes the value of a measure that will be used to switch between the three measures. You can create a measure that uses the SWITCH function to change the measure value based on the button value.

For example, you can create a measure called SelectedMeasure that uses the following formula:
SelectedMeasure = SWITCH(TRUE(),
Table2[ButtonColumn] = "Measure1", [Measure1],
Table2[ButtonColumn] = "Measure2", [Measure2ToShow],
Table2[ButtonColumn] = "Measure3", [Measure3ToShow],
BLANK())

This measure will change the measure value based on the selected button value. When the "Measure2" button is selected and more than one value is selected in the second slicer, the measure will show the value of Measure2ToShow.

4. Create a slicer that filters the values of the second slicer column. You can use this slicer to filter the values of the second slicer column and control the visibility of the two measures that you want to hide when more than one value is selected.

5. Finally, add your measures and the button to your report, and use the slicer to filter the values of the second slicer column.

By following these steps, you should be able to filter out one button based on other slicer values.