Forum Discussion

kasife's avatar
kasife
Helper V
3 years ago

Count distinct with conditional

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]))