Urgent GRAND TOTAL by Month and Grand Total Percentage by Month

[tungsh]

Hello All,

I was trying to get GRAND TOTAL by Month and Grand Total Percentage by Month in to a measure,

Sub total = =CALCULATE([Count of BP number],ALLEXCEPT(data, Data[Month])

 But still I couldn't get what I am looking for.

I need Grand Total in measure for example selected month = january, then grand total measure should show 3532. Measure is giving sum of entire data for that column.

Month	Achieve	Count of BP Number
January	Exceeded	45
January	Met	3487
February	Exceeded	15
February	Met	4187

[v-jingzhang · Accepted solution]

Hi @tungsh 

You could try below measures. 

Sub total = CALCULATE(SUM(Data[Count of BP Number]),ALLEXCEPT(Data, Data[Month]))

Sub total percentage = DIVIDE([Sub total],CALCULATE(SUM(Data[Count of BP Number]),ALL(Data)))

My [Count of BP Number] in above measures is a column in Data table. If yours is a measure, you could replace SUM(Data[Count of BP Number]) with your measure. If this still doesn't work, can you provide some dummy data and expected result more clearly?

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.