Dont Summarize data need total

[sameergupta60]

Dear Team,

we need help on don't summarise data option but requires total in the table please provide any measures for this.

attached sample data 

https://wetransfer.com/downloads/20fcc1f1566f5e6f2fe337d661dd3c1e20220926061328/f2f116

Please download file from above link

[v-stephen-msft · Accepted solution]

Hi @sameergupta60 ,

Did you want to make the total appear?

You can create a new measure to calculate the sum of the measure you created before, like the following

Measure = SUMX('Master list Actuals',[Planned YTD ASTA])

Best Regards,

Stephen Tao

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