Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi PBI experts!
I am working on a usecase that requires the report to restrict the distinct user counts to > 20.
I have multiple filters in the report so there are multiple different ways the count of users could drop down to 20 or below. Is there a way to display nothing or a message 'Cannot determine values' when the counts fall below a certain hardcoded threshold value?
Appreciate the help!
You may use ERROR Function in measures.
Measure =
IF (
CALCULATE ( DISTINCTCOUNT ( Table1[user] ), ALLSELECTED () ) > 20,
"OK",
ERROR ( "Cannot determine values" )
)
Thank you @v-chuncz-msft. This helps.
Further, in the measure is there a way to choose a specific color for the error statement?
ERROR ( "Cannot determine values" ) in Red (say) ?
This is not supported.
Thanks! The only issue with using error function in this scenario is that when I click on the 'Show Details' portion of the widget, it says that there is a calculation error which in this case is not as I am willingly introducing an error to restrict data from being displayed.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!