Forum Discussion
Invalid token
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?
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.
2 Replies
Anonymous , You are creating this as a new column? Current syntax is for a column
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.
