Visual level filter based on counted values

[Sveina]

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.

Many thanks in advance!

[lc_finance · Accepted solution]

Hi @Sveina ,

what about using an IF and a COUNT expression?

For example:

Salary new = IF(COUNT(SalaryTable[Respondent])>5,[Salary],BLANK())

This way, the salary will be shown only if there are at least records in the current selection.

Let me know if this helps you.

Regards,

LC

Interested in Power BI templates? Check out my blog at www.finance-bi.com

[Sveina]

@lc_finance thanks a lot.

I worked out with this version (just added an average calculation ahead of the second term)

New income = IF(COUNT(Table[Income]) >5;AVERAGE(Table[income]);BLANK())

Thanks again, your advice was much appreciated!

Regards
@Sveina

[lc_finance]

Perfect! I am very glad this worked out for you.

Do not hesitate if you have any more questions.

Regards,

LC