Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Second opinion on my DAX code, please. (COUNT DAX)

Hello everyone I have a table that I'm trying to count if between two numbers. See the code below. The code looks to count each row if a rate is greater than or equal to 4 and less than or equal ...
  • Anonymous's avatar
    Anonymous
    6 years ago

     

    Hi Anonymous ,

     

    Please check if this formula works.

     

     

    CALCULATE (
    COUNTROWS ( 'Current' ),
    FILTER ( 'Current', 'Current'[Rates] >= 4 && 'Current'[Rates] <= 5 )

     

     

    Regards,

    Harsh Nathani

     

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

Hi Anonymous ,

 

Please check if this formula works.

 

 

CALCULATE (
    COUNTROWS ( 'Current' ),
    FILTER ( 'Current', 'Current'[Rates] >= 4 && 'Current'[Rates] <= 5 )

 

 

Regards,

Harsh Nathani

 

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!