Count distinct with conditional

[kasife]

Hello people,

Distinct count by ID considering column A greater than column B?

Im using the following measure:

CALCULATE(
    DISTINCTCOUNT([Id]),
    FILTER(
        _table,
        _table[A]>_table[B]),
    USERELATIONSHIP(d_calendario[Date],_table[A]))

[lbendlin]

Try this

CALCULATE( DISTINCTCOUNT(_table[Id]), _table[A]>_table[B])

[kasife]

Thanks @lbendlin