cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sveina Frequent Visitor
Frequent Visitor

Visual level filter based on counted values

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Re: Visual level filter based on counted values

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

View solution in original post

3 REPLIES 3
Super User II
Super User II

Re: Visual level filter based on counted values

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

View solution in original post

Sveina Frequent Visitor
Frequent Visitor

Re: Visual level filter based on counted values

@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
Super User II
Super User II

Re: Visual level filter based on counted values

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

 

Do not hesitate if you have any more questions.

 

Regards,

 

LC

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors