Forum Discussion

Sveina's avatar
Sveina
Frequent Visitor
6 years ago
Solved

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 exper...
Need Help
  • lc_finance's avatar
    lc_finance
    6 years ago

    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's avatar
lc_finance
Solution Sage
6 years ago

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's avatar
    Sveina
    Frequent Visitor
    6 years ago

    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's avatar
      lc_finance
      Solution Sage
      6 years ago

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

       

      Do not hesitate if you have any more questions.

       

      Regards,

       

      LC