Remove selectedvalue/slicer impact

DAX DAX Calculations
6

@MIchaelGordon,

OK, clear what’s going on now. In the column chart, you had no field in the Axis well, so it had no context for Season to draw from in the measure.

In my revised solution below, I made a few changes:

  1. Replaced the table with a player slicer in the top left, and added a card for career games. For what you want to do, filtering via the table isn’t going to work. FYI - if you want to replicate the look of the table with a slicer that also shows career games, you can use the new version of SmartFilterPro to do so.

  2. Created a Harvest Player measure to make clear when one player has/hasn’t been selected. When no player is selected from the slicer, the card will read “Please select a single player” and the measure will sum career games over the whole team by season.

  3. Revised my measure to return the filters on player and team, as well as season:

    Career Games =

     CALCULATE(
     SUM( PlayerData[Games] ),
     ALLEXCEPT(
         PlayerData,
         PlayerData[Player], PlayerData[Team], PlayerData[Season]
     )
 )

Here’s what the page now looks like with no player selected:

image
image1019×564 106 KB

and with a player selected:

image
image1014×576 37.3 KB

I hope this is helpful. Revised solution file listed below.