Measure (no filtering) vs Calculated column

[SimoLeve]

Hello!

I am just trying to understand why, in this case, my measure cannot be aggregated (sum, average, etc.). Here is my measure which give the distance in km between a place on earth (46.35892453600279, -72.56697786519094) and other towns, having their lat and long coordinates in the Lat_Long table:

DistanceCTR = 12742 * ASIN(SQRT(0.5 - COS((MAX(Lat_long[LatitudeDec])-46.35892453600279)*PI()/180)/2 + COS(46.35892453600279*PI()/180) * COS(MAX(Lat_long[LatitudeDec])*PI()/180) * (1-COS((MAX(Lat_long[LongitudeDec])+72.56697786519094)*PI()/180))/2))

Normally, when I click on a measure in the field pane, I can chose a way to aggregate but for that measure, it wont work:

Normally, this is what I have (Résumé is the french equivalent of aggregate):

So, here is my question: What cause a measure to be aggregatable or not? If I do not SUM or MAX my table, I have an error related the the non uniqueness of the value. If I SUM or MAX my table, I have only one value : is it the answer to my question?

Would it be better with a calculated column? I am trying it now...

Thanks a lot,

SL

[amitchandak · Accepted solution]

@SimoLeve , Measure is having its own aggregation, so not allowed to have one at the visual or tool level.

You can have a calculated column. or see if you can use measure there