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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.