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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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