find max value based on another filtered column

Hi powerlight1 

If those colums in your  screenshot are all physical columns, you can simply use:

CALCULATE (
    MAX ( 'table'[weekStart] ),
    allecxept ( 'table', 'table'[DayCount] )
)

 Otherwise, please expound and provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

= CALCULATE( MAX( Data[weekStart] ), Data[DayCount] = 7 )

For your reference.

Step 0: I use these DATA below.

Step 1: I make a measure and a Card visual below.

    M_MaxDate = MAXX(FILTER('DATA','DATA'[DayCount]=7),'DATA'[WeekSrtart])

 

Hi powerlight1 ,

Thanks for reaching out to the Fabric Community forum.

Ahmedx , mickey64 , ThxAlot , danextian  thank you for your prompt responses.

powerlight1 following up to confirm whether the earlier replies addressed your query. If not, please share any additional questions and we’ll be glad to assist further.

Thanks,

Lakshmi.