Forum Discussion
GunnerJ
Post Patron
Post PatronCard not interacting with date filter
I have a Month/Year date filter that is currently not interacting with a card visual and I'm unsure why.
The card is based off the following measures, but shows the second measure.
DNPs = CALCULATE(DISTINCTCOUNT(Workflow[BI_SO_NBR]),ALLEXCEPT(Workflow,Workflow[BI_SO_NBR], Workflow[BI_TASK_CD], Workflow[BI_OPEN_DT]),OR(Workflow[BI_TASK_CD] = "DNPCANCUT", Workflow[BI_TASK_CD] = "DNPREMCON"), Workflow[BI_WORK_EVENT_CD]= "COMP")
% of DNPs = [DNPs]/CALCULATE( DISTINCTCOUNT(SummaryTable[BI_SO_NBR]), ALLEXCEPT(Workflow, Workflow[BI_SO_NBR], Workflow[BI_SO_TYPE_CD], Workflow[BI_OPEN_DT]), OR(Workflow[BI_SO_TYPE_CD] = "CUTOFF", Workflow[BI_SO_TYPE_CD] = "REMCUT"))
The date filter is based off a date/time column within the same table. When I select any given combo of dates in the filter my card remains unchanged. Any help or suggestions would be appreciated.
Is it possible that the allexcept features that you have in your measure(s) are rendering the date filter redundant? Without knowing what your date field is called it's impossible to say
2 Replies
jthomsonSolution Sage
Is it possible that the allexcept features that you have in your measure(s) are rendering the date filter redundant? Without knowing what your date field is called it's impossible to say
GunnerJThat was it. I added in the field my filter is based on and now functionality has returned. Thank you!