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.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
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.