Forum Discussion

kasife's avatar
kasife
Icon for Helper V rankHelper 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, ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Try this

 

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