Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Calculate End Total on a cumulative column

  • 1.  Calculate End Total on a cumulative column

    Posted Sep 14, 2021 01:37 PM

    I want to display the end total on a cumulated column:



    The second column total should be the last number in the column (eg. 1610.02). I can't use the %of grand total obviously. The field is calculated as follows:

    Cumulated Pallets =

    var currentRank = [Rank]

    Return

    if(isfiltered('Item Hits per Week'[ITEM]),
    sumx(filter(ALLSELECTED('Item Hits per Week'[Item]),[Rank]<=currentRank)
    ,calculate(sum('Item Hits per Week'[Total Pallets]))),
    [Pallets Total])

    How can I get it to display the correct number on the total line?


    ------------------------------
    Helen Hardenbergh
    d
    ------------------------------


  • 2.  RE: Calculate End Total on a cumulative column

    Top Contributor
    Posted Sep 14, 2021 03:44 PM

    Hi @Helen Hardenbergh,

    Not sur for this but try to change ISFILTERED​ by HASONEVALUE



    ------------------------------
    If any discussion or answer help, please mark it as "Recommend"
    ------------------------------

    Best regards
    Mehdi HAMMADI

    MCT | MCSA BI Reporting | MCSE Data Management and Analytics | Data Analyst Associate
    2019 Ruby Award Dynamic Communities
    ------------------------------



  • 3.  RE: Calculate End Total on a cumulative column

    Posted Sep 14, 2021 03:47 PM
    It worked, thank you!

    ------------------------------
    Helen Hardenbergh
    d
    ------------------------------