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
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