Need Help Creating a measure

Hi tnrahim,

You want the table visual to display only one record where Cumulative Average of Tickets Less Than Current Age meets the target average age, right? Also, you want a card visual to show corresponding AgeList (Days) value, right? 

If so, please first modify the formula for measure [Cumulative Average of Tickets Less Than Current Age] as below:

Cumulative Average of Tickets Less Than Current Age =
ROUND (
    CALCULATE (
        AVERAGE ( Table1[Age (Days)] ),
        FILTER (
            ALL ( Table1[Age (Days)] ),
            'Table1'[Age (Days)] < MAX ( Table2[AgeList (Days)] )
        )
    ),
    0
)

Then, create extra measures:

Measure1 = IF([Cumulative Average of Tickets Less Than Current Age]=40,1,0)

Measure2 = CALCULATE(MAX(Table2[AgeList (Days)]),FILTER(ALL(Table2),[Measure1]=1))

Add [Measure1]to visual level filters, add [Measure2] in a card visual.

Best regards,

Yuliana Gu