DISTINCTCOUNT >0

[lokesh2905]

Dear Expert,

I need to use "DISTINCTCOUNT" function in power query only when the sales quantity is >0 in my data i also have value in -1, please help me on that.


Regard's
Lokesh Sharma

 

[severynm]

Hi!

Are you looking for a DAX measure to make that calculation? Based on your message, I think that's what you want, but it's not entirely clear. If so, tty the following, remembering to substitute in the correct table/column names according to the table you are using:

=CALCULATE(DISTINCTCOUNT(Table[quantity]),Table[quantity]>0)

 

[lokesh2905]

Hi!

Are you looking for a DAX measure to make that calculation? Based on your message, I think that's what you want, but it's not entirely clear. If so, tty the following, remembering to substitute in the correct table/column names according to the table you are using:

=CALCULATE(DISTINCTCOUNT(Table[quantity]),Table[quantity]>0)

hello severynm,

thank's for your help, it's working now