cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tungsh
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.

 

MonthAchieve Count of BP Number
JanuaryExceeded45
JanuaryMet3487
FebruaryExceeded15
FebruaryMet4187
1 ACCEPTED SOLUTION
v-jingzhang
Community Support
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)))

051901.jpg

 

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.

View solution in original post

1 REPLY 1
v-jingzhang
Community Support
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)))

051901.jpg

 

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.

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors