When I try to apply top filter to only select 20 entries, it doesn't work, what could be the issue?

[ib16098]

So, I applied a top filter to select only top 20 entries, and it works, but on the table there are much more entries than twenty. What could be the issue?

[v-xicai]

Hi  @ib16098 ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @ib16098 ,

You may also need to add a column to the option "By value" when use Top N filter type.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JosefPrakljacic]

Hey @ib16098,

there's no shame in providing sample data, especially if you want a useful answer - because this way you force the community that wants to help you to guess and sacrifice time unnecessarily.

Here is a link where it is written how to get a quick answer.

Here is my attempt to give you some advice.

The following measure would be an average over categories:

AverageMeasure =
CALCULATE ( AVERAGE ( table[value] ), ALLEXCEPT ( Table, table[category] )

BR,

Josef

[ib16098]

The problem is that for each country there are several houshold expenditure based on educational level. So how could I average the houshold expenditure per country? I tried to use quick measure, and calculate the average categorizing by country and putting base value the percentage of expenditure, but it returns me the count of rows per each country with different values based on educational level.