Forum Discussion
Doing a UNIQUE Count by Server and OS.
Hi Team I am doing I am doing a COUNTA using UNIQUE of devices in another table. =COUNTA(UNIQUE(FILTER(MasterServerToApp[Server],MasterServerToApp[Wave]=B4))) What I am trying to do is determin...
=COUNTA(UNIQUE(FILTER(MasterServerToApp[OS Trim], ISNUMBER(SEARCH("Microsoft Windows", MasterServerToApp[OS Trim]))*(MasterServerToApp[Wave]=B4))))
- Hi Hans; that worked great; the only problem is if the data is not there the formula still returns a "1".
For example if I had no "Microsoft Windows" and only "Red Hat" it will still return a 1, even though the count is empty for "Microsoft Windows"
Is there any way of ignoring the 1 and turn that into a 0 if nothing is found?Frank145Try this:
=IF(SUM(ISNUMBER(SEARCH("Microsoft Windows", MasterServerToApp[OS Trim]))*(MasterServerToApp[Wave]=B4))=0, 0, COUNTA(UNIQUE(FILTER(MasterServerToApp[OS Trim], ISNUMBER(SEARCH("Microsoft Windows", MasterServerToApp[OS Trim]))*(MasterServerToApp[Wave]=B4)))))
