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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jar2019
Helper I
Helper I

DAX for Pareto Chart

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. Capture.PNG

1 REPLY 1
TeigeGao
Solution Sage
Solution Sage

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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