If you add your table to a data model in Power Pivot you can create a new measure =CALCULATE(DISTINCTCOUNT(Range[Subrow]),ALL(Range[Subrow])). Add this measure to your pivot table in the values section and filter one it.
=CALCULATE(DISTINCTCOUNT(Range[Subrow]),ALL(Range[Subrow]))