Forum Discussion
Power BI
Hi I am trying to see who have not taken a certain course or is overdue. So I have a roster where I have names and the courses they have taken and if they are overdue or not, but this data doesnot have all the names. So, I want to compare the names to one different excel data where I have all the names and compare them to get the people who have not attended the certain courses or the ones that are overdue. How do I do this?
Hi PGPowerBI ,
Because Power BI hides rows with blank summarized values, you need to enable "Show items with no data".
If you want items with no data to be shown as overdue as well, then you need to add the following measure.
M_Status = COALESCE ( SELECTEDVALUE ( Sheet1[Status] ), "Overdue" )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Hey PGPowerBI ,
load the Excel file to Power BI and then you compare it.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovicI have a Power BI file here in which there are students who have taken certain classes as well as an file where all the student names are now in this how do I create a filter or something that tells me who has not taken a certain course or overdue at certain course.
This is the excel file where I have the names of the students and the courses taken and if the certification is current or overdue.
and this is the excel file where I have all the names of the students.
Now how do I check the last excel file from this file and say the following students have not taken or are overdue in this course and same for other courses.
Please provide sample data (not images) and a depiction of the expected outcome
Hi I tried to attach earlier but it doesn't allow me but I have it uploaded to a google drive. https://drive.google.com/drive/folders/1SncRzdt7wMYRuzOC14DRBUM-l3tT9W0W?usp=sharing
So what I am trying to see as the output is when I click on a particular course I want to know who have that course as overdue and who have not taken it at all.
Hi PGPowerBI ,
Please try the measure.
Measure = COUNTROWS ( EXCEPT ( VALUES ( 'Sheet1 (2)'[Name] ), CALCULATETABLE ( VALUES ( Sheet1[Name] ), Sheet1[Status] = "Current" ) ) )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I did the exact same as you did why does my not work. I have added my power BI file here https://drive.google.com/file/d/1mirrRlmzljnWvcVXrUbIvJRvCN69dneI/view?usp=sharing
Also in the table which shows the name and the status, can we put as No record for the students who have empty overdue can be left as overdue.
Thank you for your help.
