Forum Discussion

PGPowerBI's avatar
PGPowerBI
Frequent Visitor
4 years ago
Solved

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 ha...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

     

     

PGPowerBI's avatar
PGPowerBI
Frequent Visitor
4 years ago

I 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.