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
Super User
6 years ago

Hi,

Try this measure

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

  • atharvaunde59's avatar
    atharvaunde59
    Frequent Visitor
    6 years ago

    Thanks  a lot,

    got it solved. Can u help me regarding my issues in plotting spider chart. May I DM u?