Forum Discussion

jppuam's avatar
jppuam
Helper V
4 years ago
Solved

DISTINCTCOUNT 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

Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    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's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

    Yes, but it may be simpler to use this syntax

     

    NewMeasure = CALCULATE(DISTINCTCOUNT(Table[Value]), Table[A] in {1,2,3,4,5})

     

    Pat

     

  • halfglassdarkly's avatar
    halfglassdarkly
    Responsive Resident
    4 years ago

    Yes, but you could also use the IN operator to make that more efficient.

     

    calculate(distinctcount([value]), table[a] in {1,3,5,7})