Pareto Chart

[SantiagoTorres]

Hi All,

I need help here. I got three columns with text (Quality, Safety and Environmental); I need to create a Pareto Chart counting the data in these three columns excluding the blanks. What I got at the moment is something like this:

Contributing Condition (S)	Contributing Condition (Q)	Contributing Condition (E)
MEWP or Mobile Plant
General PPE
	Installation
	Installation
		Waste management
safety documentation
Site establishment set up
		Waste management
safety documentation
	Installation
Fall hazard
scaffolding
scaffolding
Fall hazard
Dropped objects
	Documentation
Access and Egress of site
	Installation
	Documentation
Access and Egress of site
Fall hazard
scaffolding
	Installation

Obs/Type = COUNTA('2. Observations'[Contributing Condition (S)]) I need to exclude the blanks and count '[Contributing Condition (Q) and '[Contributing Condition (E)]

Then for the chart:

Pareto Chart =

VAR ObsRev = [Obs/Type]

VAR AllObs = CALCULATE( [Obs/Type], ALLSELECTED('2. Observations')) 

RETURN

DIVIDE(

SUMX(

    FILTER(

        SUMMARIZE( ALLSELECTED('2. Observations'), '2. Observations'[Contributing Condition (S)], In here I also need to exclude the blanks and also count '[Contributing Condition (Q) and '[Contributing Condition (E)]

            "Cumulative", [Obs/Type] ),

                [Cumulative] >= ObsRev ),

                    [Obs/Type] ),

    AllObs,0 )

What I'm getting at the moment is this, which is something close  to what I need,

As you can see, the blanks play a big part in the results, so I need to capture (count) just the rows, including descriptions based on each column, '[Contributing Condition (S)], '[Contributing Condition (Q) and '[Contributing Condition (E)].

Thanks for your help,

[amitchandak · Accepted solution]

@SantiagoTorres , Window function can help in that

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw