Running balance in matrix not appearing for every row/transaction

[Anonymous]

My matrix visual currently appears like this:

The measure for the 'Running Balance' column (green box) is:

ITF Reduction amount less Transaction Amount running total in Date =
CALCULATE(
    [ITF Reduction amount less Transaction Amount],
    FILTER(
        ALLSELECTED('Calendar'[Date]),
        ISONORAFTER('Calendar'[Date], MAX('Calendar'[Date]), DESC)
    )
)

The 'Running Balance' column is impacted by the 'ITF Reduction amount less Transaction Amount', which is just a net amount of the two columns previous to that one.

ITF Reduction amount less Transaction Amount = sum('Medicare'[ITF Reduction amount])-sum('CG'[Contribution])

I can see that the running balance is successfully being calculated and accommodating both the 'Contribution (CG)' and 'ITF Reduction (Medicare)' amount in its running total, however it is only appearing whenever the 'ITF Reduction (Medicare)' amount appears in the row.

How can I get the Running balance to appear for every row when an amount appears in either the 'Contribution (CG)' or 'ITF Reduction (Medicare)' column?

(I believe the root cause is due to the fact that the dates are unique between the Medicare table and the CG table, but that's just my guess).

[Anonymous]

Thanks for the suggestion. I have amended the mesure to remove the field from it, however unfortunately no change to the appearance of the matrix. 

[Anonymous]

Hi @Anonymous  

Maybe you can change 

ALLSELECTED('Calendar'[Date])

into 

ALLSELECTED('Calendar')

The difference being that ALLSELECTED specified only the table, and not the field within the table.

This link may help you:

PowerBI DAX - Running total using ISONORAFTER includes previous dates - Stack Overflow

^{Best Regards,}

^{Zhengdong Xu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the expected result very clearly.