Total of a measure

[ianboothman84]

Good afternoon 

I am having trouble showing the total of a measure in a table. I have tried sumx and having no joy. The total value in Gross bonus is showing £4924 where it should read £3603.10.

The Gorss bonus column is a measurement 

Can anyone help please 🙏

 

[v-yetao1-msft · Accepted solution]

Hi @ianboothman84 

SUMX() can be used to sum measure .I create a sample you can refer to it .

Original data :

Then create a measure to sum the value by name.

sum by name = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Name]))

Return value :

At last ,create a column to sum the measure [sum by name]:

Column = SUMX('Table',[sum by name])

The final effect is as shown :

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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

[amitchandak]

@ianboothman84 , this should not happen if it is a sum of a simple column. Usually happen with measure that uses row context

refer this

https://www.youtube.com/watch?v=ufHOOLdi_jk

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[ianboothman84]

Hello @amitchandak the column is actually a measurement. I need the total of that measure