Use measure as a Slicer

[cruzp]

Hi Team,

I have 4 measures that wanted to use as a slicer. 

Project Removed = IF(NOT(ISBLANK([Category Previous])) && [Category Current] = "Null" && ([Category Previous] <> BLANK() || [Category Current] <> BLANK()), 
		"✔", BLANK())

New to R4 = 
VAR AmountPreviousWeek = 
    CALCULATE(
        SUM(REP_REVENUE_R1_R4_SNAPSHOT[AMOUNT]),
        FILTER(
            REP_REVENUE_R1_R4_SNAPSHOT,
            REP_REVENUE_R1_R4_SNAPSHOT[SNAPSHOT_DATE_BK] = MAX('Previous Reporting Date'[Previous Reporting Date])
        )
)
RETURN IF(ISBLANK(AmountPreviousWeek) && [Category Previous] = "Null", "✔", BLANK())

Start Change = IF([Start Previous] <> [Start Current] || ISBLANK([Start Previous]) && 
    ([Category Previous] <> BLANK() && [Category Current] <> BLANK()),
	"✔",BLANK())

End Change = IF([End Previous] <> [End Current] || ISBLANK([End Previous]) && 
	([Category Previous] <> BLANK() && [Category Current] <> BLANK()),
	"✔",BLANK())

how do I do it? Please help!

[nvprasad]

Hi cruzp,

The slcier accepts only columns as input. By default you can't add measure to the slicer. You can create a small table using "Enter data" then apply your filters using some dax functions like combination of switch and selected value.

Thank you

[cruzp]

hi @nvprasad can you able to provide me detailed example since i am new to power bi as well