Count When (condition)

[#1]

Hi,

I have a problem in implementing the count function.

I am trying to insert an expression in a pivot table. The expression should return the count of glucose values for the glucose values which are less than 100.

I tried using: Count({$<Glucose={'<= 100)'}>}[Glucose])

Could someone help me out? Thanks in advance!

[#2]

Try that : count ( { <Glucose <=100> } Glucose)

[CELAMBARASAN · Accepted solution]

Hi,

     Use double quotes for less than or greater than comparison,otherwise it take its whole <=100 to compare as text.

Count({$<Glucose={"<=100"}>}[Glucose])

or

Count({$<Glucose={<=100}>}[Glucose])

Celambarasan