Forum Discussion

atharvaunde59's avatar
atharvaunde59
Frequent Visitor
6 years ago
Solved

COUNTIFS() with comparison

Hello everyone, am extremly sorry for posting for this problem again though there are lot of similar topic threads are there. I have a table with multiple columns I want to use countifs() in it bu...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi atharvaunde59 

     

     

    Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table', 'Table'[Range] < 20))

     

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Try this measure

    Measure = CALCULATE(COUNTROWS('Table'),'Table'[Range] < 20)

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi atharvaunde59 

 

 

Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table', 'Table'[Range] < 20))

 

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

  • atharvaunde59's avatar
    atharvaunde59
    Frequent Visitor
    6 years ago

    I tried that measure but its is giving me wrong output.

    I edited it as follwing 

    Measure = CALCULATE(COUNTROWS('sppu_se_comp sem_1_analysis'),FILTER('sppu_se_comp sem_1_analysis', 'sppu_se_comp sem_1_analysis'[COA_TH] < 20))
     
     
    where sppu_comp sem_1_analysis is my table name and COA_TH is column name from which I need to count no of students who's marks are less than 20.
     
    To verify it I applied filter on excel data and the actual answer is 8 but when i add that measure to card it shows count as 1
    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi atharvaunde59 ,

       

      could you share some screenshots?

      • atharvaunde59's avatar
        atharvaunde59
        Frequent Visitor
        6 years ago

        So sorry, I mistakenly attached wrong table in query to analyze.

        Got it solved! 

        Thanks a lot for help!!!