COUNTX but including a calculated column that is TRUE or FALSE
I asked a question last month about counting values based on dates, which was wonderfully answered by @v-robertq-msft. With a dataset representing the last time a series of media-playing "Faces" connected back to control I wanted to know how many had connected within 48 hours of the latest date in the "last connected" field. I've got this sorted and even been able to add extra filters into the count.
The original stuff is in the table (Players), and Robert's solution is powering the upper gauge visual on display with the Measure Online48HoursAll
However, I now have a second table called (SpecialPlayers) that lists a subset of the records in the first (for example, this could be Faces operating in a certain region). I've related these two using [FaceID] and then created a new column [IsSpecial] in (Players) that returns TRUE if that FaceID is in (SpecialPlayers), or FALSE otherwise.
I now want to do the same count into the lower gauge, but only consider those players where [IsSpecial] is TRUE. I can filter the total count easily enough by using [IsSpecial] as a filter on the visual, but I cannot figure out the way to use [IsSpecial] to modify the new Measure Online48HoursSpecial to do the same.
I'm guessing it's partially to do with COUNTX not being for logical counts, but I've not been able to include a calculated column in the ...Special Measure even when I added a calculated number value column that was the first digit of the timestamp.