Matrix with Concatenated Measures and Correct Totals

[Anonymous]

I am trying to create a matrix that shows both the sum and count for each combination of two categorical variables. I have figured out a formula that gives me the right individuals cells and one that gives the right total rows, but not both at the same time.  Trying to use HASONEVALUE(), but it isn't working.

Dummy data:

CAT1	CAT2	VAR1
A1	B1	0.25
A1	B2	0.75
A1	B2	0.5
A2	B2	0.25
A2	B2	0.5

Desired outcome:

	B1	B2	Total
A1	.25 (1)	1.25 (2)	1.5 (3)
A2		.75 (2)	.75 (2)
Total	.25 (1)	2 (4)	2.25 (5)

Thanks for the help!

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

I think you just need to drag field "var1" into the value of the matrix again and then change the type to " count"

pbix attached

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

@Anonymous - 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

Seems like you are headed down this track. You might try using ISINSCOPE instead of HASONEVALUE. Hard to say without knowing the measure formula. (hint)