Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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])
    return

    calculate(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])
    return

    calculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(all(Table),Table[First Sample Date]>= _min)
    )

1 Reply

  • Anonymous , Try like

     


    New=
    var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
    return

    calculate(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])
    return

    calculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(all(Table),Table[First Sample Date]>= _min)
    )