Check if I already done with the task/learning then return not yet done.

[Anonymous]

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 Testemail@gmai.com. 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.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I think you can try to configure Row Level Security in Power BI.

Manage Role:

Result is as below.

View as Testemail@gmai.com.

View as Testemail1@gmai.com.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Exactly what I need. Thanks alot !

[amitchandak]

@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

[Anonymous]

Unfortunately, It doesn't work.