User Profile
JonasBDM
Regular Visitor
Joined 4 years ago
User Widgets
Contributions
Pareto - Count number of type A
Hi everyone, I made this chart : 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, JL6Refresh data via power automate --> failures
Hi, Best wishes for the new year. I try to refresh automatically my power BI report (stored on power BI online) with a power automate flow but many time I failed and sometime I suceed. Does anyone have an idea about these failures? Thank you in advance JL6
