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 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 

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

3 Replies

  • Arul's avatar
    Arul
    Super 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
        Super 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