Forum Discussion

chipchidster's avatar
chipchidster
Resolver I
2 years ago
Solved

Simple filter not finding record

I'm sure this is something simple but i cannot for the life of me work out why this isn't working!   I have two tables - sprint and sprint summary. Sprint contains a row for each item in a sprint ...
Need Help
  • chipchidster's avatar
    chipchidster
    2 years ago

    Urgh okay - so in further developments, i've resolved this (i think) but I am not sure I understand how or why.

     

    Essentially I have replaced my CALCULATE with the MINX that was suggested in the first reply and it has started working!  If anyone wants to point out why this would be the case I would love to know (i'm sure i am being exceptionally dense here as both feel interchangable)

     

    MINX(
        FILTER(ALL('sprint'),  
               'sprint'[project_key] = 'sprint_summary'[project_key] &&
               'sprint'[year_week] ='sprint_summary'[year_week] &&
               'sprint'[in_scope]="Yes"),
        'sprint'[sprint_id])

    CALCULATE(MIN(sprint[sprint_id]),
              filter(sprint, 
                     sprint[project_key] = sprint_summary[project_key] &&
                     sprint[year_week] = sprint_summary[year_week] &&
                     sprint[in_scope] = "Yes")
              )

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  chipchidster ,

 

You can try the following dax

Measure =
MINX(
    FILTER(ALL('sprint'),  'sprint'[project_key]=MAX('sprint_summary'[project_key])&&'sprint'[year_week]=MAX('sprint_summary'[year_week])&&'sprint'[in_scope]="Yes"),'sprint'[sprint_id])

 

Best Regards,

Liu Yang

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