Forum Discussion
rsch91
Helper I
Helper IIgnore date filter but not everywhere
Hi all, I have a measure for the number of appointments, distinct by date. I want to plot this in a table by opdracht_ID with a date (year) slicer (from table Dim_Datum/Dim_Date). Any opdracht_ID...
bhanu_gautam
Super User
Super Userrsch91 , Try using
DAX
CALCULATE(
COUNTROWS(
DISTINCT(
SELECTCOLUMNS(
Feit_Onderhoudsopdracht_communicatie,
Feit_Onderhoudsopdracht_communicatie[Opdracht_ID],
"Datum afspraak",
FORMAT(Feit_Onderhoudsopdracht_communicatie[Gewijzigde_datum_en_tijd], "DD/MM/YYYY")
)
)
),
REMOVEFILTERS(Dim_Datum),
KEEPFILTERS(
VALUES(Dim_Datum[Year])
),
Feit_Onderhoudsopdracht_communicatie[Status] = "Afspraak huurder",
Dim_Onderhoudsopdracht[Status] = "Teruggemeld" || Dim_Onderhoudsopdracht[Status] = "Afgehandeld"
)
rsch91Helper I
Helper IThank you. Unfortunately it does not work. Still only shows the number of appointments in 2025 when filtered for 2025, while there's appointments in 2024 as well.