I have made a sort of wage-calculator in Power BI - based on income data collected from a online survey.
The table in PowerBI consist of columns such as salary, years of education, years of experienxe, managerial level etc etc. Hence there are a lot of possible combinations when you drill down and use several dimensions.
In this wage calculator I wish to prevent that users are allowed to drill down so deep that calculations are based on the data from one single repondent.
One of my diagrams is a gauge and there I have visualized the number of respondent (by count). Unfortunately I am not allowed to use this caluculation as a visual filter. What I am trying to do here is to set a minimum of 5 records behind all data labels. That is - no values in any diagram will be shown unless it is based on at least 5 records/oberservations.
Would really appreciate some good adwice on how of to deal with this issue.