Count discerpancy (?)

[mikemetrics]

Hi forum

Top right the visual is meant to count Open ID -> it counts 9

Bottom left there is a table withthe actual entries and we can only see 6 IDs from 30 to 66. I cross checked this IDs with the online platform where the data is coming from. IDs are correct. There are only 6

ID column format is text. I tend to change unique IDs to text from number so the system doesnt summarise/total UIDs

I can't see what I'm doing wrong. Help appreciated

Thanks

 

[d_m_LNK]

With the implicit count measure it is going to count all ids in that table.  You are most likely wanting to see unique IDs that are open.  I think your best bet would be to create a measure something like this to count distinct IDs that your visual will further filter on status:

Count = DistictCount(Table[id])

Or if you are truly wanting to count open IDs

OpenIDs = Calculate(DistinctCount(Table[id]), Table[Status] = 'Open')

[miTutorials · Accepted solution]

Right click on "Count of ID" and choose Count(Distinct) and see if that works !