Hi,

I am using the formula below to track an unique count of Red Hat Enterprise OS which are in a specific migration wave. However, the formula is returning a count of “1” even though there are no Red Hat Enterprise OS’s in the wave in question. How can I modify this formula to provide an accurate unique count of Red Hat devices?

=COUNTA(UNIQUE(FILTER(MasterServerToApp[Server], (MasterServerToApp[Wave] = B4) * ISNUMBER(SEARCH(“Red Hat Enterprise”, MasterServerToApp[OS Trim])))))

Below are two screenshots which prove there are “0” Red Hat Enterprise devices, however the dashboard still shows a value of “1”

Thanks,

Connor

​Hi,I am using the formula below to track an unique count of Red Hat Enterprise OS which are in a specific migration wave. However, the formula is returning a count of “1” even though there are no Red Hat Enterprise OS’s in the wave in question. How can I modify this formula to provide an accurate unique count of Red Hat devices?=COUNTA(UNIQUE(FILTER(MasterServerToApp[Server], (MasterServerToApp[Wave] = B4) * ISNUMBER(SEARCH(“Red Hat Enterprise”, MasterServerToApp[OS Trim])))))Below are two screenshots which prove there are “0” Red Hat Enterprise devices, however the dashboard still shows a value of “1”   Thanks,Connor  Read More

​