Forum Discussion

kusanagi's avatar
kusanagi
Frequent Visitor
1 year ago
Solved

Accumulated data without date

Dear all experts, I am currently transforming an excel file to PBI, but I cannot find a correct formula for column D.   Column B is a measure: qty = count('table'[ID]) Column C is also using [qty...
Need Help
  • mdaatifraza5556's avatar
    mdaatifraza5556
    1 year ago

    Hi kusanagi 

    Please check your rate measure

    3A01----Rate should be 54.69




    Create a measure for running total 

    running total =
        VAR _rnk = RANKX(
                ALLSELECTED('Table'[Item]),
                [qty_m],,
                DESC,
                Dense
               )
       
         VAR r_t =
        CALCULATE(
            [qty_m],
            FILTER(
                ALLSELECTED('Table'[Item]),
                _rnk >= RANKX(
                        ALLSELECTED('Table'[Item]),  
                        [qty_m],              
                        ,                
                        DESC,        
                        DENSE    
            )
            )
        )

        RETURN
        r_t
         
    Create measure for total (overall)

    total_m =
                 CALCULATE(
                    SUM('Table'[Qty]),
                    ALLSELECTED('Table')
                 )


    last measure to get your result

    cum_% =
        DIVIDE( [running total], [total_m], 0)

     





    If this answers your questions, kindly accept it as a solution and give kudos.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi mdaatifraza5556 ,

Thank you for being part of the Microsoft Fabric Community. Special thanks to MFelix  for suggesting the use of visual calculations with RUNNINGSUM(), which is a good  fit for your scenario with percentage values sorted in descending order and no date dependency.

 

I appreciate your quick participation in the discussion kusanagi , MFelix .

Best regards,
Yugandhar _CST Team.