Measure but I want sum in Grand total et not the calcuation of my measure

[sabine_toulouse]

Hello,

I create a measure, i put it in matrix but i want in grand total calculate sum not the calculate of my measure, How i can do that ? 

Thanks

Sabine V

[v-yangliu-msft · Accepted solution]

Hi  @sabine_toulouse  ,

Here are the steps you can follow：

1. According to your description, I created sample data.

 2. First, suppose you have a measure and find that the sum calculated by this metric is incorrect.

Measure_Sum =
IF(SUM('Table'[Amount])<1000,0,SUM('Table'[Amount]))

3. Then to calculate the sum, you can create a measure.

Calculate Sum =
var Table1=SUMMARIZE('Table','Table'[Date],"_value",[Measure_Sum])
return IF(HASONEVALUE('Table'[Date]),[Measure_Sum],SUMX(Table1,[_value]))

 4. Result.

Best Regards,

Liu Yang

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

[PaulDBrown]

@sabine_toulouse 

It sounds like you need to use ISINSCOPE, but without further information it's hard to help. Can you show the relevante measures, the expected outcome/result and if possible a sample datset or PBIX file?