Forum Discussion

RafalK's avatar
RafalK
Icon for Advocate IV rankAdvocate IV
10 years ago
Solved

Running Total on a non-date column

Hi guys, I am having some real problems with calculating a running-total in Power BI. Main problem here is that my running total should be based on a calculated measure.   Here is the problem: C...
Need Help
Tips and Tricks
Tutorial Requests
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    RafalK

     

    Please try with following Calculated Measure for the cumulative sales. It should be able to reduce the calculation.

    Cumulative_Sales_Measure =
CALCULATE (
    SUM ( Table1[Sales] ),
    FILTER ( ALL(Table1), Table1[Sales] >= MAX ( Table1[Sales] ) ),
    VALUES ( Table1[Brand] )
)

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

RafalK

 

Please make sure you’re creating a Calculated Column instead of a Measure with above formulas.

 

Regards,

jyothiK's avatar
jyothiK
Regular Visitor
3 years ago
S.noJob NameFail_countRunning_fail_count_Sum
    
1sapbw110110
2Sslog90200
3tdnxt63263
4rtxls22285

 How do i get the  S.No generated based on   Fail_count ?  and  running_count  as shown in the sample. .. Job_name and Fail_count is available.