SelectedValue from slicer to measure

[oqueffelec]

Hi, 

I have a table Veh_classif_Standardized, in which each row is a unique customer identified by the field VIN.

Each customer has a group field (group 1, 2 or 3) and a total amount spent field.

On my report, I want to create a VIN slicer so that when i click on a VIN, I get the customer's total amount spent on a card and the total amount spent average of his group on a second card.

To do so, I created 2 DAX measures : 

CurrentGroup = SELECTEDVALUE(Veh_classif_Standardized[Groupe n°])

SpentAverageCurrentGroup = CALCULATE(AVERAGE(Veh_classif_Standardized[TotalSpent]);FILTER(Veh_classif_Standardized;Veh_classif_Standardized[Groupe n°] = [CurrentGroup]))

However this does not seem to work : when I change in the slicer from a customer in a group to another customer in another group, the card with SpentAverageCurrentGroup always gives me the average of the entire table and not the average of the current group.

I would like to know what the corrrect way to do this is.  

Any help much appreciated ! 

[Anonymous]

Hi,

would be better if we could get a sample of data to work with, but off the top of my head, could you try moving your var declaration inside your calculate statement, maybe this would work?

CALCULATE (
    VAR CurrentGroup =
        SELECTEDVALUE ( Veh_classif_Standardized[Groupe n°] )
    RETURN
        AVERAGE ( Veh_classif_Standardized[TotalSpent] );
    Veh_classif_Standardized[Groupe n°] = CurrentGroup
)

[dedelman_clng]

with CALCULATE, you don't always have to explicitly use the FILTER function

try

SpentAverageCurrentGroup = 
CALCULATE
(
 AVERAGE(Veh_classif_Standardized[TotalSpent]),
 Veh_classif_Standardized[Groupe n°] = [CurrentGroup]
)

You could also try to put code for CurrentGroup into a variable call within a single expression

SpentAverageCurrentGroup = 
var CG = SELECTEDVALUE(Veh_classif_Standardized[Groupe n°])
return
CALCULATE
(
 AVERAGE(Veh_classif_Standardized[TotalSpent]),
 Veh_classif_Standardized[Groupe n°] = [CurrentGroup]
)

Hope this helps

David