CODEWITHSUNDEEP
powerbidaxpowerbi-desktop
sav
sav

Reputation: 197

PowerBi Filters not display correct values - TOPN

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.

enter image description here

Bottom 5 Profiles on Bud Diff enter image description here

Top 5 based on GP%

enter image description here

Both results are taken under this filter

enter image description here

Please find the link for .pbix file

Can Any one help me on this please?

Upvotes: 0

Views: 1402

Answers (2)

sav
sav

Reputation: 197

I have found a solution. Please download the pbix file if anybody wants to have a look.

Upvotes: 0

Jelle Hoekstra
Jelle Hoekstra

Reputation: 672

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() )

Upvotes: 1

Related Questions