Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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)
Perfect! I am very glad this worked out for you.
Do not hesitate if you have any more questions.
Regards,
LC
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |