MAX value of running total

[Alibek24]

Hello everyone!

I think I need some help in measure calculation. I have a matrix:

rows are weeks, and columns are dates. I have some incomes for each week, and I wanted to calculate % of the outcome at a particular month. Let's say for March:

1. Total outcomes for March - 264 080 000
2. Income% for 0th week: 134 235 417.39 / 264 080 000 = 50.8%
3. Income% for 1st week: 197 121 636.12 / 264 080 000 = 74.6%
4. Income% for 1st week: 203 048 547.52/ 264 080 000 = 76.9%

I tried to calculate the total outcome as a max of running total but can not find any solutions.

Are there any bits of advice?

[Anonymous · Accepted solution]

Hi @Alibek24  - 

The percentage would be someting like the following.

Notes:

    -Substitute [Payment Amount] with the measure you want to total.

    -Substitute 'Weeks Table'[Weeks Column] with the column that defines sequence in the running total.

Running Total Percent of Total = 
var week_number = MAX('Weeks Table'[Weeks Column])
DIVIDE(
	CALCULATE(
		[Payment Amount],
		'Weeks Table'[Weeks Column] <= week_number
	),
	CALCULATE(
		[Payment Amount],
		ALL('Weeks Table'[Weeks Column])
	)
)

[Anonymous · Accepted solution]

Hi @Alibek24  - 

The percentage would be someting like the following.

Notes:

    -Substitute [Payment Amount] with the measure you want to total.

    -Substitute 'Weeks Table'[Weeks Column] with the column that defines sequence in the running total.

Running Total Percent of Total = 
var week_number = MAX('Weeks Table'[Weeks Column])
DIVIDE(
	CALCULATE(
		[Payment Amount],
		'Weeks Table'[Weeks Column] <= week_number
	),
	CALCULATE(
		[Payment Amount],
		ALL('Weeks Table'[Weeks Column])
	)
)

[Anonymous · Accepted solution]

@Alibek24  - 

You could check the current value like this:

 Running Total Percent of Total = 
var week_number = MAX('Weeks Table'[Weeks Column])
IF(
    ISBLANK([Payment Amount]),
    BLANK(),
    DIVIDE(
        CALCULATE(
            [Payment Amount],
            'Weeks Table'[Weeks Column] <= week_number
        ),
        CALCULATE(
            [Payment Amount],
            ALL('Weeks Table'[Weeks Column])
        )
    )
)

[Alibek24]

---

@Anonymous wrote:

@Alibek24  - 

You could check the current value like this:

 Running Total Percent of Total = 
var week_number = MAX('Weeks Table'[Weeks Column])
IF(
    ISBLANK([Payment Amount]),
    BLANK(),
    DIVIDE(
        CALCULATE(
            [Payment Amount],
            'Weeks Table'[Weeks Column] <= week_number
        ),
        CALCULATE(
            [Payment Amount],
            ALL('Weeks Table'[Weeks Column])
        )
    )
)

---

@Anonymous thanks a lot! Everything works as needed

[Alibek24]

Thanks a lot, it worked with return after var declaring.

I have one small issue: how to get rid of other percents?