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 ,

 

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