Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
JonasBDM
Regular Visitor

Pareto - Count number of type A

Hi everyone,

 

I made this chart : 

JonasBDM_0-1648219175318.png

JonasBDM_1-1648219228689.png

 

To do it, I create this mesure that works to calculate my percentage of pareto : 

Pareto % = 
VAR ___TotalStock = calculate(sum(ATC_PRXL[Quantit� ]),ALLSELECTED(ATC_PRXL))
VAR __StockActuel =sum(ATC_PRXL[Quantit� ])
VAR __SummarizeTable = 
SUMMARIZE(
    ALLSELECTED(ATC_PRXL),
    ATC_PRXL[Code Article ],
    "Stock",SUM(ATC_PRXL[Quantit� ])
)
Var __StockCumule =
sumx(
    filter(__SummarizeTable, [Stock] >=__StockActuel),
    [Stock]
)
RETURN
__StockCumule/___TotalStock

 

Now I want to count the number of items that have a pareto percentage of less than 0.8 (On the chart , it corresponds to red color), but I can't do it ...

 

Somenone can help me please ? 

 

Thank you in advance,

 

JL6

1 REPLY 1
amitchandak
Super User
Super User

@JonasBDM , please refer this

https://exceleratorbi.com.au/pareto-analysis-in-power-bi/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.