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 projec...
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.

Konrad9090's avatar
Konrad9090
Regular Visitor
2 years ago

Hi again, 

I'll continue posting my another problem here as it is related to the same case and report. 

I've added another table to my model called 'Teams'. I need to be able to filter my visualization by team or teams and by one resource or resources. 
Filtering by teams I achieved, but I have problem how to implement in DAX measure option to filter by resource or resources. 
All my idea end up with blank visualization when I select some name of resource from slicer. 
I've uplouded my latest version of the report I anyone has idea how to resolve those problem I'll by very greatefull.
Maybe you Anonymous will be able to help. 

Link to my report.
https://drive.google.com/file/d/1ADN9aA2OkMXbinx1nukzlQdFhZ0ya0eO/view?usp=sharing