Get wrong result when I have several rows and more than 1 values

[MiloDi]

Hello dear Community, 

Hope you're doing well.

I have a problem.

I have a list of flights that have an outbound date and a scheduled date.

Based on the flight status, I create a measure that will give me a weighting.

Then I isolate the minimum status for flights with an outbound or planned date greater than 2023 with a measure.

I transform this result by assigning it a status.

I have several values

But when I want to see by flight, for Flight 2 it doesn't give me the right value. It tells me it's 1 (Achieved) when it should be 2 since it doesn't have a date greater than 2023.

Can you help me?

Thank you

Example PBI 

[Anonymous · Accepted solution]

Hi @MiloDi ,

The table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a measure named ‘lsoler_min_statut >2023’

Isoler_min_statut >2023 = MINX(FILTER('Table1','Table1'[AllerDebutReel].[Year] > 2023 || 'Table1'[PlanificationDate].[Year] > 2023),[PonderationStatut])

2. Use the following DAX expression to create a measure named ‘min_statut’

min_statut = MINX(FILTER('Table1','Table1'[AllerDebutReel].[Year] > 2023 || 'Table1'[PlanificationDate].[Year] > 2023),'Table1'[Statut ])

3. Final output

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

[MiloDi]

Hello @Anonymous 

Thanks for the solution.
I had got lost in my measurements and wasn't looking at the problem from the right angle.