Count how many times a number is repeated in a table

[Syndicate_Admin]

Hello, good afternoon.

as I can count how many times a number is repeated in a table.

For example I have this table.

In the RequestStatusId column, I want to get how many times the 6 is repeated

[Syndicate_Admin · Accepted solution]

What did help me was this:

COUNTX(FILTER(DatActivosSolicitudes, RELATED(CatSolEstatus[SolicitudEstatusId])= 6), DatActivosSolicitudes[SolicitudEstatusId])

filtering and searching by number 6

[Ashish_Mathur]

Hi,

Drag that column to the Table visual and write this measure

Count = counta(Data[RequestStatusId])

[Syndicate_Admin]

I do not know if I gave myself to explain but it was to count how many times the number 6 is repeated in the column RequestEstatusId

[Ashish_Mathur]

My solution will do exactly that.

[Syndicate_Admin]

But not all the data I have in that column is number 6