Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |