Radar Chart form Unpivoted table not responding to Filter Date

[sergioquerido]

Hello,

As observed in figure bellow, I have 2 Radar Charts with 3 measures (anchor of 100%, mean of all all players, and values of player) from a unpivoted table. However, the measures, in particular the values for each player filtered, are not responding to the filter date (range between two dates). How to solve this problem? 

Here an example of original database:

The code of one Unpivoted Table:

UnpivotedTable_Defensive = 
VAR _ORIGINAL =
ADDCOLUMNS(SUMMARIZE(Stats, Stats[Player], Stats[Cluster]),
     "Coordinates Defensive Duels", 1,
     "Coordinates Aerial Duels", 1,
     "Coordinates Loose Ball Duels", 1,
     "Coordinates Sliding Tackles", 1,
     "Coordinates Recoveries Opponent Half", 1,
     "Coordinates Back Passes", 1,

     "Player Defensive Duels", Stats[%_SummPlayerDefensiveDuels],
     "Player Aerial Duels", Stats[%_SummPlayerAerialDuels],
     "Player Loose Ball Duels", Stats[%_SummPlayerLooseBallDuels],
     "Player Sliding Tackles", Stats[%_SummPlayerSlidingTackles],
     "Player Recoveries Opponent Half", Stats[%_SummPlayerRecoveriesOpponentHalf],
     "Player Back Passes", Stats[%_SummPlayerBackPasses],
     
     "Mean Defensive Duels", Stats[%_SummClusterDefensiveDuels],
     "Mean Aerial Duels", Stats[%_SummClusterAerialDuelds],
     "Mean Loose Ball Duels", Stats[%_SummClusterLooseBallDuels],
     "Mean Sliding Tackles", Stats[%_SummClusterSlidingTackles],
     "Mean Recoveries Opponent Half", Stats[%_SummClusterRecoveryOpponentHalf],
     "Mean Back Passes", Stats[%_SummClusterBackPasses])

VAR _TABLE1 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Defensive Duels",
        "Coordinates", [Coordinates Defensive Duels],
        "Player Stats", [Player Defensive Duels],
        "Mean", [Mean Defensive Duels])

VAR _TABLE2 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Aerial Duels",
        "Coordinates", [Coordinates Aerial Duels],
        "Player Stats", [Player Aerial Duels],
        "Mean", [Mean Aerial Duels])

VAR _TABLE3 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Loose Ball Duels",
        "Coordinates", [Coordinates Loose Ball Duels],
        "Player Stats", [Player Loose Ball Duels],
        "Mean", [Mean Loose Ball Duels])

VAR _TABLE4 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Sliding Tackles",
        "Coordinates", [Coordinates Sliding Tackles],
        "Player Stats", [Player Sliding Tackles],
        "Mean", [Mean Sliding Tackles])

VAR _TABLE5 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Recoveries Opponent Half",
        "Coordinates", [Coordinates Recoveries Opponent Half],
        "Player Stats", [Player Recoveries Opponent Half],
        "Mean", [Mean Recoveries Opponent Half])

VAR _TABLE6 =
    SELECTCOLUMNS (
        _ORIGINAL,
        "Player", Stats[Player],
        "Variable", "Back Passes",
        "Coordinates", [Coordinates Back Passes],
        "Player Stats", [Player Back Passes],
        "Mean", [Mean Back Passes])


RETURN
    UNION ( _TABLE1, _TABLE2, _TABLE3, _TABLE4, _TABLE5, _TABLE6)

Example of the code for measure "Player Defensive Duels":

%_SummPlayerDefensiveDuels = CALCULATE(AVERAGEX(SUMMARIZE (Stats, Stats[Player]), CALCULATE(AVERAGE(Stats[%_DefensiveDuels]))))

Example of the code for measure "Mean Defensive Duels":

%_SummClusterDefensiveDuels = CALCULATE(AVERAGEX(SUMMARIZE (Stats, Stats[Player], Stats[Cluster]), CALCULATE(AVERAGE(Stats[%_DefensiveDuels]), VALUES(Stats[Cluster]))), ALL(Stats[Player]))

Thank you!

[lbendlin]

Please show how you linked your stats table to your calendar table.