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

[bdkanand]

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?

[Anonymous]

// 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

D

[bdkanand]

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.

[bdkanand]

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

[Anonymous]

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

[Greg_Deckler]

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