how to create cumulative% in pareto

[Anonymous]

Hi, I want to create a paerto chart use line&bar visual, the x-asix is month, and I don't know how to create a cumulative% based on month value, do you have any ideas? Thank you.

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your dataset.

Value cumulate percentage by month: =
VAR _cumulatemonthvalue =
    CALCULATE (
        [Value measure:],
        FILTER ( ALL ( Data ), Data[Month] <= MAX ( Data[Month] ) )
    )
VAR _allmonthsvalue =
    CALCULATE ( [Value measure:], ALL () )
RETURN
    DIVIDE ( _cumulatemonthvalue, _allmonthsvalue )