Forum Discussion

piaplattes's avatar
piaplattes
Regular Visitor
3 years ago
Solved

Counting specific numbers in a column

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...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    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's avatar
    Arul
    3 years ago

    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

Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

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's avatar
piaplattes
Regular Visitor
3 years ago

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's avatar
    Arul
    Icon for Super User rankSuper User
    3 years ago

    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