Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Pareto Under Review Chart = VAR TotalOverDueDocs = CALCULATE(DISTINCTCOUNT('Del PMI PLP'[Document Number]),ALLSELECTED('Del PMI PLP')) VAR CurrentOverDueDocs = DISTINCTCOUNT('Del PMI PLP'[Document Number]) Var SummarizeTable= SUMMARIZE( ALLSELECTED('Del PMI PLP'), 'Del PMI PLP'[Discipline], "Docs", DISTINCTCOUNT('Del PMI PLP'[Document Number]) ) var CumulativeSum= SUMX( FILTER(SummarizeTable, [Docs] >= CurrentOverDueDocs), [docs] ) return DIVIDE(CumulativeSum,TotalOverDueDocs)
The DAX above is what I am using to build the Pareto combo chart shown below. However, as you can tell from the picture if the column value is the same the line does not show a cumulative and the cumulative value becomes static. I think the error is in the SUMX function but I can not figure this one out. Even when the column value is the same it should still add to the cumulative total. Your help is appreciated.
Hi @jar2019 ,
Could you please share the pbix file to us for analysis? Besides, please share more information about your "the column value is the same the line does not show a cumulative and the cumulative value becomes static", do you mean that the value not changed when you are using slicer?
Best Regards,
Teige
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
66 | |
64 | |
57 |
User | Count |
---|---|
171 | |
111 | |
109 | |
72 | |
71 |