Forum Discussion

Wkbdrguy's avatar
Wkbdrguy
Microsoft Employee
8 years ago
Solved

Filtered Report based on Team assignment OR Duplicate?

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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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 )
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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's avatar
Wkbdrguy
Microsoft Employee
8 years ago

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