Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
akhmad_danial
Helper I
Helper I

Filter no data

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)

akhmad_danial_0-1641285939159.png

Does anyone have an idea?

 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @akhmad_danial 

 

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.

vzhangti_1-1641536397172.pngvzhangti_2-1641536418658.png

The results are shown in the figure.

vzhangti_3-1641536537777.png

 

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.

View solution in original post

5 REPLIES 5
v-zhangti
Community Support
Community Support

Hi, @akhmad_danial 

 

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.

vzhangti_1-1641536397172.pngvzhangti_2-1641536418658.png

The results are shown in the figure.

vzhangti_3-1641536537777.png

 

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.

Hi @v-zhangti ,

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

akhmad_danial
Helper I
Helper I

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

akhmad_danial_0-1641358463707.png

 

But, how do I achieve results like this,

akhmad_danial_1-1641358719188.png

Thanks for any help you can give

 

akhmad_danial
Helper I
Helper I

@amitchandak,

thank you for the fast response.

what do you mean "measure not tested"?  

amitchandak
Super User
Super User

@akhmad_danial , 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() ) )

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.