Forum Discussion
Conditioning Formatting Acting Wierd?
Hi HelenaX ,
Yes, your understanding is correct. The created measure is based on a certain calculation logic. Its aggregation operation is included in the created formula and is also related to its filtering context. Its data category cannot be changed. On the contrary, column is effective.
Hope to help you.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi HelenaX ,
Yes, your understanding is correct. The created measure is based on a certain calculation logic. Its aggregation operation is included in the created formula and is also related to its filtering context. Its data category cannot be changed. On the contrary, column is effective.
Hope to help you.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Henry! I will create a Measure to replace the Added Column.
I still don't fully understand why an Added Column can't be sort by field value. It is difficult to know this type of detail when a beginner wants to add a new column and later on notice that it can only be sorted by aggregated values. He/she may not even figure out that a measure would do the work without first creating a measure and comparing it with the Added Column.
Your help is really appreciated!
Helena