ALL except filter set in column header
<p>A complete newbie to PowerPivot here. I have a calculated column where I count the number of distinct rows like this:</p>

<pre><code>=COUNTROWS(
    DISTINCT(
        Data[Chain]
    )
)
</code></pre>

<p>However this does not take into account any filters manually applied in a column's header. I have 11 chains, and if I filter out all except two I want this column's value to be 2 instead of 11. How can I achieve this in PowerPivot?</p>

<p>Thanks in advance!</p>