Use DAX Measure as a Slicer

[cruzp]

Hello Team,

I believe that slicier accepts only columns as input. By default I can't add measure to the slicer.

How do i create a workaround to have the below DAX as a filter/slicer?

I heard that it has something to do with creating a small table, "enter data" and applying filters using some dax functions like combination of switch and selected value.

But i don't know how to implement it. Please help.

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())

Thanks!

[Ashish_Mathur]

Hi,

Share some data (in a format that can be pasted in an MS Excel file), explain the question and show the expected result.

[cruzp]

Hi @Ashish_Mathur 

here is the link for the updated question with sample data and expected output

https://community.fabric.microsoft.com/t5/Desktop/Use-DAX-Measure-as-a-slicer-for-the-table-in-the-r...

[cruzp]

i will post a new one, and i will tag you there thanks @Ashish_Mathur 

[cruzp]

any type of help is appreciated! Thanks!

[cruzp]

@Anonymous hi, can you help me on this?