topic customized subtotal in DAX Commands and Tips

customized subtotal

cson123 — Mon, 10 Mar 2025 19:03:59 GMT

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:

Re: customized subtotal

Greg_Deckler — Mon, 10 Mar 2025 20:03:27 GMT

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

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.

Re: customized subtotal

ahmetyilmaz — Mon, 10 Mar 2025 20:45:29 GMT

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.

Re: customized subtotal

cson123 — Mon, 10 Mar 2025 21:50:01 GMT

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

Re: customized subtotal

Anonymous — Mon, 12 May 2025 17:32:39 GMT

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.

Re: customized subtotal

Anonymous — Sun, 18 May 2025 12:45:14 GMT

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.

Re: customized subtotal

Anonymous — Thu, 22 May 2025 16:58:17 GMT

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