Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display a notification if no data found

Hi there

 

I have some data about employees in a table called 'Referrals', and a separate dimension table for employee names called 'DimEmployee'. The 'Referrals' table does NOT contain information about all employees.

 

I have a visual holding a sum of all referrals from the 'Referrals' table. 

 

When you select an employee from a slicer which usese the 'DimEmployee' table, if they are not found in the referrals table, the visual disappears or shows NaN.

I don't mind this, but what I want is a data card perhaps which appears in these circumstances and says 'No referrals found'. 

So almost the opposite of an IF(ISCROSSFILTERED function. I anticipate something like this:

IF(ISNOTFOUND('DimEmployee'),"No referrals found",BLANK()))  But obviously there is no such argument as ISNOTFOUND (I wish there was!)

 

Help!

  • You could try something like this in your card measure

     

    Rows Found = IF(ISBLANK(COUNTROWS(Referrals)), "No Referrals Found", "See Table For Results")

     

    Regards,

    Pat

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee

    You could try something like this in your card measure

     

    Rows Found = IF(ISBLANK(COUNTROWS(Referrals)), "No Referrals Found", "See Table For Results")

     

    Regards,

    Pat

    • Anonymous's avatar
      Anonymous
      Not applicable

      Well bloody hell mahoneypat that was quick, and it works perfectly. Thanks!