Forum Discussion

jprousseau's avatar
jprousseau
Frequent Visitor
5 years ago
Solved

Measure not adding correctly

Hi    i have measure not tally corectly. Measure = SUMX ( VALUES (data[Contract] ), CALCULATE ( AVERAGE( (data[Premium] ) ) ) )   The premium for the 1st 2 rows must only be added once...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi jprousseau ,

     

    Try the following measure:

    Measure_new1 = 
var _summarize=SUMMARIZE('data',[Date].[Year],[Date].[Month],"1",[Measure_new])
return
IF(
HASONEVALUE(data[Date].[Month]),[Measure_new],SUMX(_summarize,[1]))

     

     

    Best Regards,
    Henry

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Fowmy's avatar
Fowmy
Super User
5 years ago

jprousseau 
Try this way:

 

Measure =
SUMX
(
 data,
  data[Premium]  
)

 

 

If you need to average:

 

Measure =
AVERAGEX
(
 data,
  data[Premium]  
)