Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
Yes, but it may be simpler to use this syntax
NewMeasure = CALCULATE(DISTINCTCOUNT(Table[Value]), Table[A] in {1,2,3,4,5})
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Yes, but you could also use the IN operator to make that more efficient.
calculate(distinctcount([value]), table[a] in {1,3,5,7})
Yes, but it may be simpler to use this syntax
NewMeasure = CALCULATE(DISTINCTCOUNT(Table[Value]), Table[A] in {1,2,3,4,5})
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks mahoneypat 🙂