Count distinct rows based off one column and add filters WITHOUT Calculate? (Direct Query)

[RYU209]

Hello,

I'm trying to count the distinct values in a column with filters without using CALCULATE because I am using a Direct Query. 

So far I have COUNTROWS(FILTER(Table, Table[A] = "1")) which counts every row with the filter condition but I'm not sure how to make it filter only on the distinct values in a given column as well. 

[tamerj1 · Accepted solution]

@RYU209 
Please try

=
COUNTROWS (
    DISTINCT (
        SELECTCOLUMNS (
            FILTER (
                'Table',
                'Table'[A] = "1"
            ),
            "@B", 'Table'[B]
        )
    )
)

[RYU209]

That worked perfectly. Thank you!