Forum Discussion

PowerBIuser_2's avatar
PowerBIuser_2
New Member
3 years ago
Solved

Filter pie chart based on USERPRINCIPALNAME

Hi,  I have the following table1: Task Status user1 user2 1 Completed Other Other 2 Completed USERPRINCIPALNAME Other 3 Pending Other USERPRINCIPALNAME 4 Pending USERPR...
Need Help
  • PowerBIuser_2's avatar
    PowerBIuser_2
    3 years ago

    I found the solution with the following measure:

    Measure2 = CALCULATE(COUNT(table1[Status],

    table1[user1]=USERPRINCIPALNAME() ||

    table1[user2]=USERPRINCIPALNAME()

    )