how to avoid sum in subtotal of matrix for a measure

[Anonymous]

Hi, I want to create a measure that when applied in matrix the total and subtotal should not work, just keep the max/min/avg value in that group, for example,

the data is like this:

category	sub_category	value
A	A1	3
A	A2	2
B	B1	3
B	B2	1
B	B3	2

when added the category and sub_category to rows and measure to values in matrix, and turn on the total, it should be like this:

A	Total	3
	A1	3
	A2	2
B	Total	3
	B1	3
	B2	1
	B3	2
Total		3

the subtotal and total only returns max value of sub_category or category, do you know how to solve it?

[Idrissshatila]

Hello @Anonymous ,

click on the down arrow on the fild in the visualization pane and click on don't summarize

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Anonymous]

actually there is no such a menu in filed pane and I want to make it work use DAX because this measure should be used by other measure to get some metrics

[Idrissshatila]

Hello @Anonymous,

check this article whcih they have a section called

DAX Solution To Control Totals & Subtotals In A Matrix Visual In Power

https://blog.enterprisedna.co/matrix-visual-in-power-bi-controling-totals-subtotals/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin