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