Forum Discussion

Tiago01oliveira's avatar
Tiago01oliveira
New Member
2 years ago

VAR Loses Drillthrough Filter After Using ALL

The title may be a bit confusing but i have 2 pages, a club page that drills through to a player page with more information, this drill through uses Player ID, from table Player Details. I then have ...
Need Help
vgarciasouza's avatar
vgarciasouza
Frequent Visitor
2 years ago

I believe the answer is to use ALLEXCEPT.

 

Perhaps is:

ALLEXCEPT('Player Details', [Player])

  • Tiago01oliveira's avatar
    Tiago01oliveira
    New Member
    2 years ago

    I changed the All to ALLEXCEPT and it still has the same effect unfortunately

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Tiago01oliveira 

      Try the following measure.

      Similar Players Metric =
VAR SelectedPlayerShots = [Selected Player ShotsOnTarget]
VAR LowerBound = SelectedPlayerShots * 0.9
VAR UpperBound = SelectedPlayerShots * 1.1
RETURN
    CALCULATE (
        IF (
            AND (
                SUM ( 'Graph Table'[SOT  Similarity] ) >= LowerBound,
                SUM ( 'Graph Table'[SOT  Similarity] ) <= UpperBound
            ),
            1,
            VALUE ( SelectedPlayerShots )
        ),
        ALLSELECTED ( 'Player Details' ),
        'Player Details'[ID] IN VALUES ( 'Player Details'[ID] )
    )

      Best Regards!

      Yolo Zhu

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