Vote for the improvement to Filtering:
https://ift.tt/2l17Fms
While thinking about the Filter problem, I decided to check to see if the data profile improvements had been added to Power Query in Excel, and they are! You can now see how many distinct and unique items there are in each column.