Visual Level filter - Top condition is working for only one column

[rajendraongole1]

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

[v-diye-msft · Accepted solution]

Hi @rajendraongole1 

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