Forum Discussion

Konrad9090's avatar
Konrad9090
Regular Visitor
2 years ago
Solved

Visualization to show cross projects

Hello PowerBI masters, 

I would like to ask you how to solve problem which I found in my task. 
I need to create a chart that shows the project and the teams that are working on a specific project.
But I have to show only projects where is more than one team. 
I have 3 main tables which I'm using to achieve some results. 
Employees 
Projects 
EmployeeBooking where I have estimated hours for specific project.
This is my pbix file with some visualization. 
TestCrossTeams.pbix - Google Drive

I'm trying to achive stacked chart which be focusing only on Projects with multiple teams. 
But the problem is than I don't know how to filter out Project with single team. 
My measure to count Teams:

Count Cross Teams =
COUNTROWS(
    SUMMARIZE(
        'EmployeeBookings',
        Projects[Name],
        Employees[Team]
    )
)
Sorry for creating another account and the same topic. But I am having trouble logging into my old microsoft account.
If anyone could help with those problem I will be very greateful 🙏

Have a nice day!
Konrad
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Konrad9090 

    You can refer to the following measure

    Measure =
VAR a =
    SUMMARIZE (
        ADDCOLUMNS (
            ALLSELECTED ( EmployeeBookings ),
            "Projects", RELATED ( Projects[Name] ),
            "Team", RELATED ( Employees[Team] )
        ),
        [ID Project],
        [Projects],
        [Team]
    )
VAR b =
    COUNTROWS ( FILTER ( a, [Projects] IN VALUES ( Projects[Name] ) ) )
RETURN
    IF (
        b > 1,
        COUNTROWS (
            FILTER (
                a,
                [Projects]
                    IN VALUES ( Projects[Name] )
                        && [Team] IN VALUES ( Employees[Team] )
            )
        )
    )

    Output

     

    Best Regards!

    Yolo Zhu

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