Possible to show a message if no rows returned? (like SSRS does)

[OneWithQuestion]

I have a measure that looks for exceptions, missing bills for a billing period.

*If a contract is active AND we have hours logged to it, then that customer should have had a bill generated and sent, otherwise someone forgot to do their job.

Anyway, NO NEWS is GOOD NEWS.  People should come there and see nothing to know all is well.

However, I would like to do an "if no rows returned" type of message like "Congrats, none of your contracts were missing billed hours" or some such.

SSRS had that option, is there anything in Power BI that can do that?

Maybe I do a measure in a textbox or something??  A new measure called "NoRowsReturnedForMissingBills" that does IF "MissingBills = True" then it returns???

Thoughts?

[v-sihou-msft]

@OneWithQuestion

In Power BI, it's not supported to directly custom message if no row reutrns like SSRS. For your requirement, I suggest you create a measure like:

=
IF ( COUNTROWS ( Table ) < 0, "Custom Message", BLANK () )

Regards,

[OneWithQuestion]

Is that possible to address an object in PowerBI?

Like "count of rows displayed in a grid on the PowerBI page?" or was "table" a reference to a table in the data model?

Can you reference the count of rows in a table or matrix on a PowerBI report?

Thanks!