Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
Try this
CALCULATE( DISTINCTCOUNT(_table[Id]), _table[A]>_table[B])
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |