Forum Discussion

sarahp's avatar
sarahp
Frequent Visitor
5 years ago

PowerBI Cumulative Total / Duplicate Values

Hi all,   I have been struggeling with this problem for quite a while now. I’m trying to calculate a cumulative total of IssueId’s for each category.  The formula I have now looks like this: ...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

Add a small random number to your values to break the ties.

sarahp's avatar
sarahp
Frequent Visitor
5 years ago

Hi lbendlin 

If i add a random number the statement and result look like this:

ISINSCOPE(IssueCategoryHierarchy[Hierarchy_L2_Text]),
Var TotalIssues2 = CALCULATE(COUNT(IssueStatus[IssueId]),ALLSELECTED(IssueStatus))
Var CurrentIssues2 = COUNT(IssueStatus[IssueId])
Var SummarizedTable2 =
summarize(
ALLSELECTED(IssueStatus),
(IssueCategoryHierarchy[Hierarchy_L2_Text]),
"XZ", [NumberOfIssueId]
)
Var CumulativeSum2 =
Sumx(
FILTER(SummarizedTable2, [XZ] >= CurrentIssues2 ),
[XZ] )
Return
CumulativeSum2,

 

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    A little less small? Does not need to be all positive either.

    • sarahp's avatar
      sarahp
      Frequent Visitor
      5 years ago

      Could you please give me an example code?

      • lbendlin's avatar
        lbendlin
        Super User
        5 years ago

        for example 

         

        x - 0.05 + RAND()*0.1