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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
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.