Invalid token

[Anonymous]

Hi, so i am trying to use a formula 

Is Above Median PT = if([PT (m)]>MEDIAN([PT (m)]), "Yes", "No") 

However the PT(m) first one is showing as grey and i am not able to execute this formula. This particular value is not getting detected. However the PT(m) after the median is getting detected. Any idea why this is happening?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Agree with @amitchandak . There are some differences between calculated column and Measure. You could try the following syntaxs to get the expected output.

• For calculated column:

Column = if([PT (m)]>MEDIAN([PT (m)]), "Yes", "No") 

• For Measure:

Measure = IF(SUM('Table'[PT (m)]) >CALCULATE( MEDIAN('Table'[PT (m)]),ALL('Table'))  , "Yes", "No")

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You are creating this as a new column? Current syntax is for a column