Use Parameter to Slice Aggregate Measure?

Hi Anonymous 

Here are two methods:

The first one is to use the field parameter:

I create a set of sample data:

Then add two measure:

N = 
CALCULATE (
    SUM ( 'Table (2)'[daysonjob] ),
    FILTER ( ALLSELECTED ( 'Table (2)' ), 'Table (2)'[laboronsite] = "N" )
)

Y = 
CALCULATE (
    SUM ( 'Table (2)'[daysonjob] ),
    FILTER ( ALLSELECTED ( 'Table (2)' ), 'Table (2)'[laboronsite] = "Y" )
)

Add the two measure as parameter:

The result is as follow:

The second method:

Create a new table:

Table = {"Y","N"}

Then add a measure:

Measure = 
VAR _Newvalue = SELECTEDVALUE('Table'[Value])
VAR _labor = SWITCH(
    _Newvalue,
    "Y","Y",
    "N","N"
)
RETURN     
    CALCULATE (
        SUM ( 'Table (2)'[daysonjob] ),
        FILTER ( ALLSELECTED ( 'Table (2)' ), 'Table (2)'[laboronsite] = _labor )
    )

Create a slicer with table[value] and a card with the measure:

The result:

Best Regards

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