Forum Discussion
Dax Measure with dynamic date
I need help.
I am trying to create a measure that counts the # of items ordered since an account was created. I manually keyed 01/01/2022 in the measure below and was able to get the result I expected.
COUNTROWS(
GROUPBY(FILTER(Table,Table[First Sample Date]>= DATE(2022,01,01)),Table[Sample ID],Table[Order Choice Type])
)
Unfortunately, I can't figure out how to update the syntax in the measure to dynamically display correctly based on the minimum date in the visual or a slicer.
COUNTROWS(
GROUPBY(FILTER(Table,Table[First Sample Date]>= CALCULATE(min('Calendar'[DATE]),ALLSELECTED('Calendar'[DATE])),Table[Sample ID],Table[Order Choice Type])
)
Below are screenshots of the baseline (with the expected values) as well as the incorrect values based on my failed attempt.
Any help is appreciated!
Anonymous , Try like
New=
var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
returncalculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(Table,Table[First Sample Date]>= _min)
)or
New=
var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
returncalculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(all(Table),Table[First Sample Date]>= _min)
)
1 Reply
- amitchandak
Super User
Anonymous , Try like
New=
var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
returncalculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(Table,Table[First Sample Date]>= _min)
)or
New=
var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
returncalculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(all(Table),Table[First Sample Date]>= _min)
)