Forum Discussion
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...
I found the solution with the following measure:
Measure2 = CALCULATE(COUNT(table1[Status],
table1[user1]=USERPRINCIPALNAME() ||
table1[user2]=USERPRINCIPALNAME()
)
PowerBIuser_2, Calculate a fifth column say "final user" - to populate with "USERPRINCIPALNAME" if user1 or user2 = USERPRINCIPALNAME. Filter by this "final user" column.
meenakp Power BI gives me the following error: USERPRINCIPALNAME function is not supported on calculated columns
I found the solution with the following measure:
Measure2 = CALCULATE(COUNT(table1[Status],
table1[user1]=USERPRINCIPALNAME() ||
table1[user2]=USERPRINCIPALNAME()
)