Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm trying to produce a visual that shows the most effective method of candidate attraction by % using TOPN filter on a visual.
I'm not interested in sources which have less than 25 applicants.
The problem I am running into is that those with less than 25 applicants are consistently in the top 5 by %.
The TOPN doesn't account for the greater than 25 applicants and I end up with a table that only shows 1 result.
Example of the result with/without the Greater than 25 filter.
I'm sure I could do this and create an additional table but I'd really rather not - any one have any ideas on a way around this. Happy to re-write a dax measure if I need to.
WIthout greater than 25 filter
With the less than 25 filter
Solved! Go to Solution.
While the TOPN filter in the filter panel is fantastic, and should always be your first choice, it does have some limitiation mainly in that is entirely dependent on the current filter context. This may not always be what you want. In such cases it's ok to implement your own logic via the DAX TOPN() or even via completely custom code.
Hi,
Share data in a format that can be pasted in an MS Excel file. Explain the question and show the result very clearly.
While the TOPN filter in the filter panel is fantastic, and should always be your first choice, it does have some limitiation mainly in that is entirely dependent on the current filter context. This may not always be what you want. In such cases it's ok to implement your own logic via the DAX TOPN() or even via completely custom code.
Hi @lbendlin
I took this approach in the end, but a little differently.
I just used a variable to retain the total number of applications then on the return statement used and IF logic to set any with under 25 applicant to -1 so they would never be in the top 5.
Problem solved 😄
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
74 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
85 | |
64 | |
59 | |
56 |