Forum Discussion
Can't select Data Type for a mesure?
A measure is made with a DAX expression, and it already has the aggregator in it. For eg, if your column name is [Sales], you can make a measure called
TotalSumSales = sum([Sales])
You wouldn't be able to change the aggregation for measures. (and you can know a measure by the "calculator" icon before it's name in the field list.
You can change the aggregation for the column name though. For eg, for [Sales], you can click on the column name and change it's aggregation.
I think you are clicking on a measure and not the base column of the measure.
SqlJason wrote:A measure is made with a DAX expression, and it already has the aggregator in it. For eg, if your column name is [Sales], you can make a measure called
TotalSumSales = sum([Sales])
You wouldn't be able to change the aggregation for measures. (and you can know a measure by the "calculator" icon before it's name in the field list.
You can change the aggregation for the column name though. For eg, for [Sales], you can click on the column name and change it's aggregation.
I think you are clicking on a measure and not the base column of the measure.
Thanks for your answer Jason,
Can you explain further the last part of your post? I know the calculator icon shows me that is a measure but I don't know where is the base column of the measure you say, in the query editor?
Here is a table I want the totals of the last 2 columns (which are measures) to show by average, right now it will be the same because there is only data for January but when data for febreary comes it will sum the two months. Is what a want possible to do?
Thank you so much and good luck!!