Filtered Report based on Team assignment OR Duplicate?

[Wkbdrguy]

I have been using PivotTable from excel to find an incorrect data assignment, such as finding 2 teams assigned to the same server. There can be around 5000+ ticket entries. How can I produce a report/table in Power BI that will either show me if a server gets more than 1 team assigned OR show me if there is a duplicate server with a different team? 

*Highlighted rows are the incorrect items

[Zubair_Muhammad · Accepted solution]

Hi @Wkbdrguy

With PowerBI desktop, you can directly create a calculated table to get the Final Results

Go to Modelling Tab>>NEW TABLE and enter this code

Final result =
CALCULATETABLE (
    Table1,
    FILTER (
        ALL ( Table1[Server] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[Team] ) > 1 )
    )
)

[Wkbdrguy]

Exactly what I was looking for. This worked out great.

[Zubair_Muhammad]

@Wkbdrguy

Please see file attached as well