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.
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi  Schwurblini 

 

try like:

 

5To10Count :=
COUNTROWS(
    FILTER(
        TableName, 
        TableName[AllTopNodes]>=5
            &&TableName[AllTopNodes]<=10
    )
)