Custom Totals Based on Matrix Levels

Hi NT2  - Create Base Measure (Row Logic)

Custom Amount =
VAR total =
CALCULATE(
SUM(Fact[Amount]),
Fact[Group] = MAX(Fact[Group]),
Fact[Type] = MAX(Fact[Type]),
Fact[Date] = MAX(Fact[Date])
)
RETURN
IF(
ISINSCOPE(Groupping[Class]) && NOT ISINSCOPE(Groupping[Group]),
total,
IF(
MAX(Groupping[Type]) = "A" && ISINSCOPE(Groupping[Group]),
SUM(Fact[Amount]) * 0.6
)
)

This measure works row-by-row — do not use this for the total row.

If you want the total of what shows at the Class level, do this

Custom Amount (Class Total) =
IF(
HASONEVALUE(Groupping[Class]) || ISINSCOPE(Groupping[Group]),
[Custom Amount], -- Keep row-level logic
SUMX(
VALUES(Groupping[Class]),
CALCULATE([Custom Amount])
)
)

try to fix the , total at the Group level

Custom Amount (Group Total) =
IF(
ISINSCOPE(Groupping[Group]),
[Custom Amount], -- At group row, show the usual logic
SUMX(
VALUES(Groupping[Group]),
CALCULATE([Custom Amount])
)
)

Try the above and let know.

https://dax.guide/isinscope/

Hi NT2,
Thank you for reaching out to the Microsoft fabric community forum. Thank you rajendraongole1, for your inputs on this issue.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.    

Dax Measure for Measure_WithClassTotal in Fact table:

Measure_WithClassTotal =

VAR CurrentValue =

    [Measure_Base]



VAR IsTotalRow =

    NOT ISINSCOPE(Groupping[Class]) &&

    NOT ISINSCOPE(Groupping[Group])



RETURN

    IF(

        IsTotalRow,

        SUMX(

            VALUES(Groupping[Class]),

            CALCULATE([Measure_Base])

        ),

        CurrentValue

    )

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.