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()

    )

PowerBIuser_2's avatar
PowerBIuser_2
New Member
3 years ago

Hi Greg_Deckler,

Thanks for your quick response.
I don't use RSL, because in my dashboard I also have a table that I apply the Measure1 in the filter (Measure1 is "1") and only the USERPRINCIPALNAME tasks appear.

My problem is with the pie chart. In Details section I can put the user1 and then the filter with the Measure1 works fine, but only apply the filter for the user1 column. I need take in account both columns: user1 & user2, as the table does.

The table show me 3 task as a USERPRINCIPALNAME (it's correct), but I don't get the same result in the pie chart...