customized subtotal

[cson123]

Hello. I am fairly new to PowerBI. I am trying to build a matrix that has a subtotal where it only adds when "Weekday" is Monday through Friday. I already have subtotals which adds up all the days, but I just need to add Monday through Friday. Would I need a new measure and if so, how would I go about getting this customized subtotal? Any info would be greatly appreciated. Thank you!!

WHAT I HAVE NOW:

WANT:

[v-nmadadi-msft]

Hi @cson123 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks 

[v-nmadadi-msft]

Hi @cson123 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @cson123 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. If not please provide an update on the issue so that we can look into it.

Thank you.

[cson123]

@Greg_Deckler This is my data. I want to ultimately only add Monday through Friday and also have another total for Monday through Saturday. Is this possible?

Month	Weekday	8	9	10	11
OCT
	Monday	253	281	336	366
	Tuesday	227	347	452	460
	Wednesday	250	328	417	500
	Thursday	224	313	396	403
	Friday	199	357	373	358
	Saturday	24	47	38	100
Total Verified (M-F)		1153	1626	1974	2087
Total Verified (M-S)		1177	1673	2012	2187
NOV
	Monday	188	217	284	305
	Tuesday	206	313	446	420
	Wednesday	183	256	429	402
	Thursday	177	218	295	258
	Friday	209	317	414	422
	Saturday	40	75	118	105
Total Verified (M-F)		963	1321	1868	1807
Total Verified (M-S)		1003	1396	1986	1912

[ahmetyilmaz]

Hello, it is not possible to make a 2nd total in powerbi tables , instead you can make this calculation with measure and show it in a different table.

[Greg_Deckler]

@cson123 First, please vote for this idea: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Matrix-Table-grand-totals-with-Measures/idi-p...

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

If you need more specificity, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.