Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sveina
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
lc_finance
Solution Sage
Solution Sage

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
lc_finance
Solution Sage
Solution Sage

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

@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

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

 

Do not hesitate if you have any more questions.

 

Regards,

 

LC

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.