Dynamic Filter

ahmadhammoud — Fri, 09 Aug 2024 12:50:38 GMT

Dears,
i have a table with multi Date for example:
ID, Arrive Date, Charge Date, Dischare Date
and i have a date slicer from 2020 to 2024
i need to filter the table have the column mentioned above by a drop down list
so if selected value from the list is Arrive then filter the table where Arrive Date between
---> if slicer is filtered so filter the table between the slicer min and max dates
---> if slicer is not filter so filter the table between last start and end month
the below DAX not working with error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
FIN_List_Posting_Date_Filter =
VAR DateList = SELECTEDVALUE(My_Report_Date[Report],"Posting Date")
VAR SlicerMIN = MIN(DateTimeTable[DateTime])
VAR SlicerMAX = MAX(DateTimeTable[DateTime])
/*VAR StartDateMIN= IF(NOT(ISFILTERED(My_Report_Date[Report])),[StartDate])
VAR StartDateMAX= IF(NOT(ISFILTERED(My_Report_Date[Report])),[EndDate])*/
VAR
PostedFilter = SWITCH( TRUE(),
DateList ="Posting Date" , IF(ISFILTERED(DateTimeTable[DateTime]),
CALCULATETABLE(
FILTER(Charges,
Charges[POSTED_DT_TM] >= SlicerMIN &&
Charges[POSTED_DT_TM] <= SlicerMAX + TIME(0, 59, 59))),
CALCULATETABLE(
FILTER(Charges,
Charges[POSTED_DT_TM] >= [StartDate] &&
Charges[POSTED_DT_TM] <= [EndDate]+1))))

RETURN PostedFilter

Re: Dynamic Filter

lbendlin — Fri, 09 Aug 2024 17:09:17 GMT

Use a disconnected table for your slicer, and a measure filter for the visual.