subtotal blank for running total in matrix

[mahendi]

I have the following matrix and table, the subotal is missing in the running totals where the category is empty.

Category	Sub Category	Sub Category 2	Amount	Date
1	1.1	1.1.1	1	01/01/20
1	1.2	1.2.1	1	01/02/20
1	1.3	1.3.1	1	01/03/20
1	1.1	1.1.2	1	01/04/20
1	1.2	1.2.2	1	01/05/20
1	1.3	1.3.2	1	01/06/20
2	2.1	2.1.1	1	01/06/20
2	2.1	2.1.2	1	01/05/20
2	2.2	2.2.2	1	01/04/20
2	2.2	2.2.1	1	01/03/20
2	2.3	2.3.1	1	01/02/20

I used quick measure for running total - 

Amount running total in Category =

CALCULATE(

    SUM('Sheet1'[Amount]),

    FILTER(

        ALLSELECTED('Sheet1'[Category]),

        ISONORAFTER('Sheet1'[Category], MAX('Sheet1'[Category]), DESC)

    )

)

is there a way to display the running total in subtotal where the category has no values?

[mahoneypat]

I added some February rows for only Cat 1 to your sample data to reproduce your issue.  Your measure worked fine for me when I did.  Is this the needed behavior?

Regards,

Pat

[mahendi]

@mahoneypat  The grand total is there, but the subtotal is still missing even in your table.

[mahoneypat]

Please try this expression.  It references your existing measure but should replace it in the visual.

NewMeasure = SUMX(VALUES('Sheet1'[Category]), [Amount running total in category])

Regards,

Pat

[mahendi]

@mahoneypat  sorry it did not work

it does not fill the blank sub total and has also replaced running total with category total