Forum Discussion

MuthalibAbdul's avatar
MuthalibAbdul
Helper II
2 years ago
Solved

Compare two columns

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

audreygerred's avatar
audreygerred
Super User
2 years ago

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.