Count distnict values in table before expand it

[Anonymous]

Hi this is what I want to do is count unique values based on one column before expand the table.
I need this because there are so files that should not be included from today and the most easy way to fit solution to already existing query is just unfilter some files that will have too many unique in my specific column.
Any solution how to do it?

[Anonymous]

Working thanks

[ImkeF · Accepted solution]

Hi @Anonymous ,
you can add a column that counts the distinct values like so:

List.Count(List.Distinct([Transform file][<YourTableNameGoesHere>]))