Measure with conditional sum or percentage

Question

I try to get percentage of totals, but matrix show total all percentage.Matrix show total Revenue, Expenses, Profit and percent of profit over revenue.Can't find any idea how to form measure with condition to avoid sumimg percentages.&nbsp;Category Name&nbsp; &nbsp; &nbsp; &nbsp; Dept&nbsp; &nbsp; Total1&nbsp; &nbsp; &nbsp; &nbsp; Revenue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D1&nbsp; &nbsp; &nbsp; &nbsp;700&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D2&nbsp; &nbsp; &nbsp; &nbsp;500 2&nbsp; &nbsp; &nbsp; &nbsp; Exp&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D1&nbsp; &nbsp; &nbsp; &nbsp;800&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D2&nbsp; &nbsp; &nbsp; &nbsp;2003&nbsp; &nbsp; &nbsp; &nbsp; Profit&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D1&nbsp; &nbsp; &nbsp; -100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D2&nbsp; &nbsp; &nbsp; &nbsp;3004&nbsp; &nbsp; &nbsp; &nbsp; Profit %&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45.7 there is sum(-14.3+60.0) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; instead 16.7% as Profit % of total profit &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; over total Revenue (as 200/1200) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D1&nbsp; &nbsp; &nbsp;-14.3 (as -100/700)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D2&nbsp; &nbsp; &nbsp; 60.0 (as 300/500)

v-yulgu-msft · Accepted Answer

Hi&nbsp;sekic,
&nbsp;
The "Total" column in Matrix sums up detailed records per row group, it is not able to change this default behavior to make it&nbsp;do a different calculation for&nbsp;some specific groups.
&nbsp;
As a workaround, you can try this measure:
Total = SUM(Test4[Amount])

Sub total =
IF (
    SELECTEDVALUE ( Test4[Name] ) = "Profit%",
    CALCULATE (
        SUM ( Test4[Amount] ),
        FILTER ( ALL ( Test4 ), Test4[Name] = "Profit" )
    )
        / CALCULATE (
            SUM ( Test4[Amount] ),
            FILTER ( ALL ( Test4 ), Test4[Name] = "Revenue" )
        ),
    CALCULATE ( SUM ( Test4[Amount] ), ALL ( Test4[Dept] ) )
)

&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

Measure with conditional sum or percentage

1 Reply

Related content

Conditional Measure

Card Conditional Formatting Measure Percentage

Odd Percentage Measure Behavior

Percentage by group

Conditional formatting variance percentage