Forum Discussion

karkar's avatar
karkar
Helper III
9 years ago

DAX

Hello,   I am trying to flag patients who had been given a medicine within 48 hours of admission.   Any suggestions are highly appreciated.   Count = DISTINCTCOUNT(query[24hourflag])-1 Example...
Need Help
Sean's avatar
Sean
Community Champion
9 years ago

karkar

Okay =>DISTINCTCOUNT counts ALL blanks as 1 distinct value

 

This means ALL Rows in the [24Hourflag] Column that are BLANK will count as 1 => meaning this 1 will be added to the Total

 

Say you have 5 distinct non-blank values  => your formula without the -1 will return 6

 

because 5 distinct non blank + 1 for all blanks

 

so the - 1 deducts the blanks

 

Does this make sense? :smileyhappy:

 

EDIT:

Look at the picture....

DISTINCTCOUNT will return 3

without - 1 or the FILTER function filtering out the blanks

karkar's avatar
karkar
Helper III
9 years ago

So it will group all the Non Blanks (counts all non blanks which is 5 in your example) and all the blanks(count will be 1 for all of them).

 

When we say -1 , it removes the group which has a count of 1?

 

Is that right??

 

COUNT_ID     COUNT_BKLANK

5                             1

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi karkar,

    As the Sean said, DISTINCTCOUNT counts ALL blanks as 1 distinct value, all BLANK will count as 1. So  -1 , it removes the BLANK group.

    Best Regards,
    Angelia