Forum Discussion
customized subtotal
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:
6 Replies
- Greg_DecklerCommunity Champion
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/n4TYhF2ARe8If 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. - ahmetyilmazAdvocate II
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.
- cson123New Member
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 - v-nmadadi-msftCommunity Support
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.
- v-nmadadi-msftCommunity Support
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-msftCommunity Support
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