Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |