DAX: Value in one table that lands between a minimum and maximum in another table

[rinabernardo]

I have 2 tables, one containing a value and another with details of date ranges. Here are the details:

TCERs Data table contains the Age in Days for each TCER.

TCER id	Creation Date	Age in Days
XXXX	MM/DD/YYYY	6

Age Groups table contains rows for each date range (1-7, 8-14,...) along with corresponding Minimum and Maximum values. The table looks like this:

Range	Minimum	Maximum
01-07	1	7
08-14	8	14

I need a measurement (that can be placed on a timeline) which will count the number of TCERs whose Age in Days falls between the minimum and maximum of a specified range.

[v-rongtiep-msft · Accepted solution]

Hi @rinabernardo ,

Please create a measure.

Measure = CALCULATE(COUNTROWS('TCER data table'),FILTER(ALL('TCER data table'),'TCER data table'[Age in Days]<=SELECTEDVALUE('Table'[Maximum])&&'TCER data table'[Age in Days]>=SELECTEDVALUE('Table'[Minimum])))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Polly

[TomMartens]

Hey @rinabernardo ,

I assume this article describes what you are looking for: Dynamic segmentation – DAX Patterns

Hopefully, this provides what you are looking for.

Regards,

Tom