Compare two columns

[MuthalibAbdul]

Hello PBI users,

I have been trying to find a solution to this problem for a few hours but did not succeed. I have a table with a list of all students that should be in my class. Another table I have has a list of the students, exam subjects, scores, date of exam etc. 

Now I have an interactive dashboard, where I select month or week or quarter and I get the list of students that were present that week or day, their scores and other details. But I need to know the list of students that were not present as well. 

The problem is one table is complete and has all unique rows with student name while other table has multiple rows for a single student (diff subjects, location, etc). Basically a 1 to many relationship.

I tried using the except function but have not been able to figure out a solution. 

Other solutions I checked online are all of static reports, I need this on a recurring basis (interactive dashboard) and based on selection, it should show me the list of names not present. 

[v-rongtiep-msft · Accepted solution]

Hi @audreygerred ,

Thanks for your quick response.

Hi @MuthalibAbdul ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Measure = IF(MAX('Table (2)'[Column2])<>"y",1,BLANK())

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[MuthalibAbdul]

Thanks so much this helped

[audreygerred]

When you add the names from your students table to the visual, right click on that field in the visualization pane and select 'Show items with no data'. This will make the students who don't have data appear.