Forum Discussion
Check if I already done with the task/learning then return not yet done.
I have 2 tables here, completed and mandatory.
The idea is I want to know the learnings that I'm not yet done by comparing these 2 tables.
For example, I log in as [email protected]. As you can see in the completed learnings table I have 2 completed learnings, I want to return learnings from the mandatory learnings table that are not present in the completed learnings table.
Does anyone know if this is possible with Power BI or how can I execute this in Power BI?
Please note that RLS is being applied. Thank you.
Hi Anonymous ,
I think you can try to configure Row Level Security in Power BI.
Manage Role:
Result is as below.
View as [email protected].
View as [email protected].
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
Anonymous ,
measure =
var _sel = summarize(allselected(completed), completed[unique id])
return
countrows(filter(Mandatory, not Mandatory[Unique ID] in _sel) )
plot this with Mandatory learning title
Hi Anonymous ,
I think you can try to configure Row Level Security in Power BI.
Manage Role:
Result is as below.
View as [email protected].
View as [email protected].
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
