Forum Discussion
New Measure | Not behaving Accordingly?
Anytime you create Measures you need to aggregate the columns you want to reference.
What is happenning is - Intellisense is helping you by not letting you select a Column without you aggregating it somehow first!
Look at this example...
Measure with FORMAT = FORMAT ( SUM ( Table[Gross] ) - SUM ( Table[Tax] ) - SUM ( Table[Deductions] ), "Currency" )
When you create a Column because it will be evaluated on every row there's no need for aggregation
(you can of course aggregate also depending on what you want the result to be)
Hope this helps!:smileyhappy:
Okay I think it's the FORMAT command - it only works for New Column and not for New Measure... WHY? I'm still trying to find out... unless someone from here would like to help explain this.
Thank you.
Anytime you create Measures you need to aggregate the columns you want to reference.
What is happenning is - Intellisense is helping you by not letting you select a Column without you aggregating it somehow first!
Look at this example...
Measure with FORMAT = FORMAT ( SUM ( Table[Gross] ) - SUM ( Table[Tax] ) - SUM ( Table[Deductions] ), "Currency" )
When you create a Column because it will be evaluated on every row there's no need for aggregation
(you can of course aggregate also depending on what you want the result to be)
Hope this helps!:smileyhappy: