Counting specific numbers in a column

[piaplattes]

Hello everyone,

i need help counting specific numbers in a column. I have a column called "Gesamt NPS" and i wolud like to count all rows, that have the numbers 0,1,2,3,4,5,6,7. The result should be the number of rows, that have the numbers 0-7. The Name of the table is "NPS Rohdaten". 

I am thankful for every tip. 

Best regards 

[Arul · Accepted solution]

@piaplattes ,

try this formula in measure,

Count of no's = 
COUNTAX(FILTER('NPS Rohdaten','NPS Rohdaten'[Gesamt NPS]<=7),'NPS Rohdaten'[Gesamt NPS])

Thanks,

Arul

[Arul · Accepted solution]

@piaplattes ,

try this formula in measure,

Count of no's = 
COUNTAX(FILTER('NPS Rohdaten','NPS Rohdaten'[Gesamt NPS]<=7),'NPS Rohdaten'[Gesamt NPS])

Thanks,

Arul

[piaplattes]

It worked! thank you a lot 🙂 what would be the measure if i only want the amount of rows with the numbers 8 and 9 in it? 

[Arul · Accepted solution]

@piaplattes ,

try this,

Count of no's = 
COUNTAX(FILTER('NPS Rohdaten','NPS Rohdaten'[Gesamt NPS]=8 || 'NPS Rohdaten'[Gesamt NPS]=9),'NPS Rohdaten'[Gesamt NPS])

Thanks,

Arul