Forum Discussion

RobotBroer's avatar
RobotBroer
New Member
3 years ago
Solved

Add column based of calculation of multiple rows

I have a table with many projects, each row representing a task of a project where each task has a milestone and a status. I want to filter my matrix table to show only completed tasks where the who...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi RobotBroer ,

    Here's the DAX solution. Create a calaulated column.

    MILESTONE REACHED =
IF (
    COUNTROWS (
        FILTER (
            'Table',
            'Table'[Project Name] = EARLIER ( 'Table'[Project Name] )
                && 'Table'[Task Status] <> "done"
        )
    ) > 0,
    "FALSE",
    "TRUE"
)

    Result:

    I also attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

     

RobotBroer's avatar
RobotBroer
New Member
3 years ago

Thank you,

 

I just had to add another dimension for the milestone too:

 

MILESTONE REACHED =
IF (
    COUNTROWS (
        FILTER (
            'Table',
            'Table'[Project Name] = EARLIER ( 'Table'[Project Name] )
             && 'Table'[Milestone] = EARLIER ( 'Table'[Milestone] )
                && 'Table'[Task Status] <> "done"
        )
    ) > 0,
    "FALSE",
    "TRUE"
)