Forum Discussion
Power BI
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.
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.
v-kkf-msftCommunity Support
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.
- v-kkf-msft
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.