Measure not adding correctly

[jprousseau]

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.

Please see screenshot. 

@amitchandak @Angith_Nair 

[v-henryk-mstf]

Hi @jprousseau ,

According to your mistake, I did a test to get the correct result, refer to the following:

Measure_new = 
VAR _summarize =
    SUMMARIZE ( 'data', [User], [Contract], "1", [Measure] )
RETURN
    IF ( HASONEVALUE ( data[User] ), [Measure], 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.

[jprousseau]

@v-henryk-mstf 

Thanks for your help. The measure works now but when i use it in a month breakdown it is still wrong.

maybe just something small. i have uploaded the pbix again to https://drive.google.com/drive/folders/11BrpV3LsGQGiZNJHG70y4lLHxoEaA2Ku

Thanks

[v-henryk-mstf · Accepted solution]

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]

@jprousseau 
Try this way:

Measure =
SUMX
(
 data,
  data[Premium]  
)

If you need to average:

Measure =
AVERAGEX
(
 data,
  data[Premium]  
)

[jprousseau]

Get this error

[Fowmy]

@jprousseau 

Can you explain what you are trying to calculate? share a sample of our data.

[jprousseau]

Here is the link

https://drive.google.com/file/d/1ynCnJY-7k6VBEa286TmvRQYYf-RlS8tH/view?usp=drivesdk