Pareto Diagram

You need a tie breaker. Add a small random number to each of the values.

Hi El_Bastien 

Thanks for the reply from lbendlin.

The following testing is for your reference.

My sample:

Create two measures as follow:

Your [Q1 Total Count] looks like a measure, and since I don't know its calculation logic, I created [Q1 Total Count1] to restore your scene, and in your scene, you can use [Q1 Total Count] directly.

Pareto = 
VAR _AllSelectedAns = 
    ALLSELECTED('Data for PBI'[Question 1 Answers])
VAR _CurrentCount1 = 
    [Q1 Total Count1]
VAR _CumQ1Table = 
    FILTER(
        _AllSelectedAns,
        [Q1 Total Count1] <= _CurrentCount1
    )
VAR _CumQ1 = 
    SUMX(
        _CumQ1Table, 
        [Q1 Total Count1]
    )
RETURN
IF(
    ISINSCOPE('Data for PBI'[Question 1 Answers]),
    _CumQ1
)

Pareto % = 
VAR _TotalCount = 
    CALCULATE(
        SUM('Data for PBI'[Q1 Total Count]),
        ALL('Data for PBI'[Question 1 Answers])
    )
VAR _CumulativeCount = [Pareto]
RETURN
DIVIDE(_CumulativeCount, _TotalCount, 0)

Output:

Best Regards,
Yulia Xu

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

Hello, 

You can use visual "Pareto+" to create a graph and table.  The visual with do all of the calculations for you.  You can also use "Pareto by sio2Graphs" to produce the graph, no need for measures.

😀

sio2Graphs

sio2graphs on AppSource 

Data on Git