Forum Discussion
Use DAX Measure as a Slicer
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!
5 Replies
- cruzp
Helper V
Anonymous hi, can you help me on this?
- cruzp
Helper V
any type of help is appreciated! Thanks!
- Ashish_Mathur
Super User
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
Helper V
i will post a new one, and i will tag you there thanks Ashish_Mathur
- cruzp
Helper V
Hi Ashish_Mathur
here is the link for the updated question with sample data and expected output