cancel
Showing results for
Did you mean: New Member

## Urgent GRAND TOTAL by Month and Grand Total Percentage by Month

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
1 ACCEPTED SOLUTION  Community Support

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.  Community Support

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.  