Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Measure returns same value for all rows in matrix

I know there's a similar thread for this issue, but I'm new to DAX and I'll admit the advice given went over my head.    My measure is meant to return the due date for the last task of a particular...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    I simulated some data hoping to restore your problem. Please check the attachment.

    EndofWork = 
CALCULATE ( MAX ( FactTasks[DueDate] ),
    FILTER ( ALL ( DimTasks ),
        DimTasks[TaskType] = "Software - Work Planning"
            && [ProjectID] = SELECTEDVALUE ( FactTasks[ProjectID] )
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Anonymous 

For the ProjectId in your table visual, where does it come from?