I have a dataset as below. I have ranked profiles based on revenue. And then I selected profiles which have ranks lower than 30 using a filter. From that 30 I wanted to filter top 5 profiles based on GP% and bottom 5 profiles based on bud diff. But the results are not correct.
Bottom 5 Profiles on Bud Diff
Top 5 based on GP%
Both results are taken under this filter
Please find the link for .pbix file
Can Any one help me on this please?
The problem is that the filters are acting independently of each other, they are not evaluated as AND. There is no way to do this with regular filters but you can do a little trick.
By adding the following measure to your report and by referring to it in your topn filter in the value field you can get it done. What this measure does, is that it only leaves values for the top 30 you've selected. When using that to pick the bottom 5, it limits the values it can select to the 30 clients you've filtered already.
IF ( [Rank] <= 30 ; SUM ( Sales[Bud Diff] ) ; BLANK() )
ranks higher than 30but in your filter I see<=30which is correct. – AnkUser