Forum Discussion
jppuam
Helper V
Helper VDISTINCTCOUNT with multiple OR
Hello,
is it possible to have a measure that does distinct count, filter with multiple "OR", like this :
calculate(distinctcount(value), filter(table, a=1 || a=3 || a=5 || a = 7)
thanks,
JP
Yes, but it may be simpler to use this syntax
NewMeasure = CALCULATE(DISTINCTCOUNT(Table[Value]), Table[A] in {1,2,3,4,5})
Pat
3 Replies
- mahoneypat
Microsoft Employee
Yes, but it may be simpler to use this syntax
NewMeasure = CALCULATE(DISTINCTCOUNT(Table[Value]), Table[A] in {1,2,3,4,5})
Pat
jppuamThanks mahoneypat 🙂
halfglassdarklyResponsive Resident
Yes, but you could also use the IN operator to make that more efficient.
calculate(distinctcount([value]), table[a] in {1,3,5,7})