1. Create a Measure for Distinct Count:
DistinctCountProduct = COUNTROWS(SUMMARIZE('TableName', 'TableName'[ProductID]))
2.Create a Flag Measure:
DistinctCountFlag =
IF([DistinctCountProduct] > 10, "Yes", "No")
3. Apply Visual-Level Filter:
Add a visual to your Power BI report.
Drag the DistinctCountFlag measure to the "Values" area of the visual.
Go to the "Visualizations" pane and select the "Filter" icon.
Under "Visual level filters", find the DistinctCountFlag measure.
Set the filter condition to show values where the measure is "Yes" (or "No" based on your requirement).
Now, the visual will only display data when the distinct count condition you've set is met.
4. Customize as Needed:
You can adjust the conditions in the DistinctCountFlag measure to fit different criteria or apply to different columns as needed.