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 determine out of those devices which Operating systems is running on them. I did this with a helper column and using this formula. =UNIQUE(COUNTIFS(MasterServerToApp[OS Trim],”*Microsoft Windows”,MasterServerToApp[Wave],B4))
The problem being the number are not adding up to what the first formula is providing. Is there any way to combine the two formulas where is pulls the unique count from the “Server” column and pulls in the “OS Trim” column to give me the unique count of Windows machines?
Dashboard Results. As you can see the number of devices is 17, but is over counting by 3.
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 determine out of those devices which Operating systems is running on them. I did this with a helper column and using this formula. =UNIQUE(COUNTIFS(MasterServerToApp[OS Trim],”*Microsoft Windows”,MasterServerToApp[Wave],B4)) The problem being the number are not adding up to what the first formula is providing. Is there any way to combine the two formulas where is pulls the unique count from the “Server” column and pulls in the “OS Trim” column to give me the unique count of Windows machines? Dashboard Results. As you can see the number of devices is 17, but is over counting by 3. Read More