Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need help with DAX Measure to for Cumulative %.

    I am trying to replicate the column in yellow in Power BI. In Power BI I already have the rank working along with the totals and complete total (257 in first screen shot) In Excel...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I got it working:  I created 2 measures:

    Total Defects Part No Cumulative % =
    VAR CurrentRank = [DefectPartRankv2]
    RETURN
    SUMX(
        FILTER(
            ALLSELECTED('NCMDefects_Last60Days'),
            [DefectPartRankv2] <= CurrentRank
        ),
        [Total Defects Part No]
    )
     
    Then this one:
    Total Defects Part No Cumulative % All = [Total Defects Part No Cumulative %]/[Total Defects Part No All]
     
    That seemed to resolve it, I took a step back and looked at the qtys and then total qtys.  
    Thank you for your help anyway!
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Let me play with that, I can try to send sample data, and a PBIX file. 

Here is the same data in Power BI and I will try what you sent over in Dax: