Filtering summarized table

[ITManuel]

Hi all,

I've got the following table:

I would like to create a new table which identifes for which "INVOICECODE" there are more than 1 "VATCODES". I summarized the table as follows:

Now I would like to filter the summarized table obtaining a table which only contains "INVOICODES" for which "CountVATCode" is greater then 1.

I tried with surrounding FILTER  and CALCULATETABLE, but i was not able to obtain it.

Thanks in advance

Regards

[Fowmy · Accepted solution]

@ITManuel 

Try this please:

EVALUATE
FILTER(
	//THE TABLE YOU CREATED//,
	[CountVATCODE] > 1 
)

[ITManuel]

Hi Fowmy,

thanks, it works. I tried this before but haven't used [ ] brackets around "CountVATCode" consequently Filter couldn't recognize it.

Thanks again.

Best regards