Filter no data

[Anonymous]

Hi There,

I have a schedule of doing antibody tests every workday of the week for all employees,

Schedule test once a week and starts on Monday until Friday.

I want to filter who hasn't had an antibody test every week.

I have 3 tables (calendar, user,  and user test)

Does anyone have an idea?

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Measure:

Remarks = IF(countrows(UserTest)<>BLANK(),"Yes","No")

Measure = IF([Remarks]="Yes",BLANK(),"RED")

Set the background color to Measure.

The results are shown in the figure.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-zhangti ,

Thank you very much, It is going to take me some time to understand how this works. I appreciate this support.

[Anonymous]

I added 2 columns in UserTest Table, to make it easier to find usernames that haven't been tested.

But, how do I achieve results like this,

Thanks for any help you can give

[Anonymous]

@amitchandak,

thank you for the fast response.

what do you mean "measure not tested"?  

[amitchandak]

@Anonymous , Assuming you have table test and use 

Create a measure on test.

tested = countrows(test)

measure not tested

countx(filter(values(User[User]) , if(isblank([tested]),[User], blank() ) )