Forum Discussion

SimoLeve's avatar
SimoLeve
Frequent Visitor
4 years ago
Solved

Measure (no filtering) vs Calculated column

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
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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