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)

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

You are welcome.  If my reply helped, please mark it as Answer.  If you second question is related to this, post it here, else please start a new thread.