Forum Discussion

Schwurblini's avatar
Schwurblini
Frequent Visitor
3 years ago
Solved

Filter between two values

Hi All I am trying to count between two values, specifically i want to count all values between 5 and 10. I created the following measure:   More than 5 per month = CALCULATE ( COUNT('Weekly...
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago
    More than 5 per month =
    CALCULATE (
    COUNT('Weekly Sales'[All Topnodes]),
    FILTER('Weekly Sales', (COUNT('Weekly Sales'[All Topnodes]) >= 5 && COUNT('Weekly Sales'[All Topnodes]) < 10 )
    ))

    Schwurblini I hope this post is helps.
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago
More than 5 per month =
CALCULATE (
COUNT('Weekly Sales'[All Topnodes]),
FILTER('Weekly Sales', (COUNT('Weekly Sales'[All Topnodes]) >= 5 && COUNT('Weekly Sales'[All Topnodes]) < 10 )
))

Schwurblini I hope this post is helps.
  • Schwurblini's avatar
    Schwurblini
    Frequent Visitor
    3 years ago

    Amazing thanks, i knew there was something i overlooked, thanks for the fast response.