Date Slicer

Anonymous 

Create a new table for Date Types:

DateType = DATATABLE("Date Type", STRING, {{"Date_exam"}, {"Date_release"}})

Create a measure to filter based on selected values

Filtered Result =
VAR SelectedDateType = SELECTEDVALUE(DateType[Date Type])
VAR SelectedDate = SELECTEDVALUE(dim_date[Date])

RETURN
IF(
SelectedDateType = "Date_exam",
CALCULATE(
COUNTROWS(Dile_fact),
Dile_fact[Date_exam] = SelectedDate
),
IF(
SelectedDateType = "Date_release",
CALCULATE(
COUNTROWS(Dile_fact),
Dile_fact[Date_release] = SelectedDate
)
)
)

Use the Filtered Result measure in the table to see the filtered count based on the slicer selections.

💌If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn