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. T...
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
Super User
Super UserAnonymous , You are creating this as a new column? Current syntax is for a column