Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX Measure filter value different slicer's selected value

Hi,   I have the following table :   Name Status Team AHP 1  A Team A AHP 2 B Team A AHP 3 C Team A AHP 4 A Team B AHP 5 B Team B AHP 6 C Team B AHP 7 A Te...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Based on my testing, if there is multiple values selected in the slicer, please try the following methods:

    1.Drag the Table Team field into the slicer visual.

    2.Create the new measure to calculate the number for each status.

    Total team = CALCULATE(
        COUNTROWS('Table'),
        ALLEXCEPT('Table', 'Table'[Status])
    )

    3.Create the new measure to calculate the selected values on a slicer.

    Team selected = 
var tea = VALUES('Table'[Team])
RETURN
CALCULATE(
        COUNTROWS('Table'),
        FILTER(ALLEXCEPT('Table', 'Table'[Status]), 'Table'[Team] in tea)
    )

    4.Create the new measure to calculate the values exclude the slicer selected.

    Exclude selected = [Total team] - [Team selected]

    5.Drag the measure into the table visual. The result is shown below.

    Best Regards,

    Wisdom Wu

    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 Anonymous ,

First of all, many thanks to mh2587  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Drag the slicer table Team field into the slicer visual.

3.Create the new measure to filter value.

 

Measure_Name = 
VAR SelectedTeam = SELECTEDVALUE('Table slicer'[Team])
RETURN
    CALCULATE(
        COUNTROWS('Table'),
        FILTER(
            ALLEXCEPT('Table', 'Table'[Status]),
            'Table'[Team] <> SelectedTeam
        )
    )

 

4.Select Drag the status field and measure into the table visual.

5.The result is shown below.

 

Best Regards,

Wisdom Wu

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

Anonymous Hi, 

Thank you again. I applied your solution and I have one question, if there is multiple values selected in the slicer, what should I adjust in the measure please ? 

 

Regards,

Tg

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Based on my testing, if there is multiple values selected in the slicer, please try the following methods:

    1.Drag the Table Team field into the slicer visual.

    2.Create the new measure to calculate the number for each status.

    Total team = CALCULATE(
        COUNTROWS('Table'),
        ALLEXCEPT('Table', 'Table'[Status])
    )

    3.Create the new measure to calculate the selected values on a slicer.

    Team selected = 
var tea = VALUES('Table'[Team])
RETURN
CALCULATE(
        COUNTROWS('Table'),
        FILTER(ALLEXCEPT('Table', 'Table'[Status]), 'Table'[Team] in tea)
    )

    4.Create the new measure to calculate the values exclude the slicer selected.

    Exclude selected = [Total team] - [Team selected]

    5.Drag the measure into the table visual. The result is shown below.

    Best Regards,

    Wisdom Wu

    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

      Anonymous Many thanks for your help. 😊