Forum Discussion

WestWinter's avatar
WestWinter
Helper II
4 years ago
Solved

Changing code to reference a slicer?

Hi All,   So I have the below code which gives the value in TableA, where the field is "Asia" and the id matches in Table A with Table B.     ExposureA = VAR Output = CALCULATE(SUM(TableA[value...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi WestWinter ,

    According to your description, field and value are all in tableA, you want the measure filtered by the field slicer, you don’t need to write TableA[field]=””, just put field in slicer, it automatically works.

    ExposureA =
CALCULATE (
    SUM ( 'TableA'[Value] ),
    FILTER ( 'TableA', 'TableA'[ID] = MAX ( 'TableB'[ID] ) )
)

    Best Regards,
    Community Support Team _ kalyj

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

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

You should be able to use SELECTEDVALUE just like you do with [id].

 

ExposureA =
VAR Output =
    CALCULATE (
        SUM ( TableA[value] ),
        FILTER (
            TableA,
            TableA[field] = SELECTEDVALUE ( SlicerTable[field] )
                && TableA[id] = SELECTEDVALUE ( TableB[id] )
        )
    )
RETURN
    Output​