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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

survey reports Dont like to show if less then 2 by any filtering

 hi

I have requirment in survey report were in , i dont have show staff members if they are less then 2 in that catogery by using any filter 

how can solve this pls Hlp.

Thanks

1 ACCEPTED SOLUTION
pranit828
Community Champion
Community Champion

HI @Anonymous 

measure1 = CALCULATE(COUNTA(table[staff member]), ALLEXCEPT(table,table[staff member]))

 

and  use this measure in the right side filter pane to hsow when more than 2

pranit828_0-1597274742359.png.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

View solution in original post

1 REPLY 1
pranit828
Community Champion
Community Champion

HI @Anonymous 

measure1 = CALCULATE(COUNTA(table[staff member]), ALLEXCEPT(table,table[staff member]))

 

and  use this measure in the right side filter pane to hsow when more than 2

pranit828_0-1597274742359.png.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.