topic Re: In matrix table, able to sum Column total but unable to sum row total in DAX Commands and Tips

In matrix table, able to sum Column total but unable to sum row total

bdkanand — Sat, 30 May 2020 02:04:31 GMT

Hello,

I have created the below formula to identify how many times in an 8 week period the user did not meet the 96% threshold. We created the following formula, which returns a "1" to indicate the threshold had not been met, this threshold is a consolidated percentage of per week. For example, in given 8 weeks of time, if any weeks percentage are below 96% returns 1.

I have created a matrix table, when i populated the data i am getting the row totals correctly but my column total is incorrect as shown in below image.Could you please help me to fix it?

Re: In matrix table, able to sum Column total but unable to sum row total

Greg_Deckler — Thu, 21 May 2020 13:33:30 GMT

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

Re: In matrix table, able to sum Column total but unable to sum row total

Anonymous — Sun, 24 May 2020 12:32:36 GMT

// Please try to learn about when // to use which functions. Also, // SUMMARIZE should not be used to // do anything else than grouping. // Please go to dax.guide/summarize/ // and take a good look at the arguments // and then read the articles to which // links you'll find toward the end // of the description. // And here's your measure: [TC total] = MAXX ( VALUES( 'Calendar'[Week Ending date] ), [TC Percent] )

Best

Re: In matrix table, able to sum Column total but unable to sum row total

bdkanand — Sat, 30 May 2020 02:05:38 GMT

no this measure is not giving me a result which i am looking for. I am getting a correct total of column because i have used the summarize function on calendar table. As i told above, values 1 and 0 are consolidated result of 1 week so if i want to sum them i have to group them else it will sum the value of every row which i don't need it.

Re: In matrix table, able to sum Column total but unable to sum row total

bdkanand — Tue, 26 May 2020 14:55:57 GMT

Anonymous Could you please guide me in right direction as i am new to powerbi

Re: In matrix table, able to sum Column total but unable to sum row total

Anonymous — Tue, 26 May 2020 18:34:58 GMT

Well, I can't even if I wanted. I don't understand the measures, especially [TC%]. You'd have to explain clearly what you want to do from the ground up starting from the first principles. You'd have to also explain the data model and give some example data. If I were you, I would remove all the unnecessary columns from the model, leave only the ones that count for the case in question and then explain clearly what you want to do and how your measures should work with single days as well as with ANY period of time.

Otherwise, it's not possible to help. At least I can't.

Sorry.

Best
D