Forum Discussion
Super UserVisual Level filter - Top condition is working for only one column
Hi Power Bi User,
I am trying to apply a filter conditions at visual level filter with top 5 records of my customer and top 5 countries..
i am not able to place two dimension filters with top N results. can you please suggest is there any way to get the filtering?
Please suggest.
Above is the error i am facing.
Regards,
Rajendra
If you’d like to filter the TOP 5 of customer and TOP 5 countries by the same argument (i.e. [Sales]), you can use the TOP N filter once, and you’ve got the 2 dimensions results.
If you’d like to filter TOP 5 of customer by sales, and TOP 5 countries by volume, it’s not accessible to apply them in same visual coz the logic is mixed up. You can use the measure below, and filter the measure without blank:
Measure 3 = IF(RANKX(ALL(Table1),CALCULATE(SUM(Table1[Sales])))>5||RANKX(ALL(Table1),CALCULATE(SUM(Table1[Volume])))>5,BLANK(),1)
Best regards,
Dina Ye
2 Replies
- v-diye-msft
Community Support
If you’d like to filter the TOP 5 of customer and TOP 5 countries by the same argument (i.e. [Sales]), you can use the TOP N filter once, and you’ve got the 2 dimensions results.
If you’d like to filter TOP 5 of customer by sales, and TOP 5 countries by volume, it’s not accessible to apply them in same visual coz the logic is mixed up. You can use the measure below, and filter the measure without blank:
Measure 3 = IF(RANKX(ALL(Table1),CALCULATE(SUM(Table1[Sales])))>5||RANKX(ALL(Table1),CALCULATE(SUM(Table1[Volume])))>5,BLANK(),1)
Best regards,
Dina Ye
- v-diye-msft
Hi rajendraongole1 ,
If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
Best regards,
Dina Ye