Forum Discussion

Imam01's avatar
Imam01
New Member
2 years ago

How to Calculate Cumulative Percentage

I am trying to calculate a cumulative percentage i.e. row 1 will be 2.76% and row 2 will be 5.34% etc. % of Trips with Blank Driver is a measure and does not belong to a table. All other columns belo...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Imam01 OK, well then maybe this. Also, left out the very important ALL or ALLSELECTED from previous reply but it is in this one:

     

    Cummulative Measure = 
  VAR __Index = [_Top 10 Blank ID Vehicles Ranking]
  VAR __Table = SUMMARIZE(ALL('Vehicle'), [Index], [Vehicle License Plate], [Unique Vehicle ID], [Owner ID], "__PercentTrips", [% Trips with Blank Driver], "__Index", [_Top 10 Blank ID Vehicles Ranking])
  VAR __Result = SUMX( FILTER( __Table, [__Index] <= __Index ), [__PercentTrips])
RETURN
  __Result

     

     

    • Imam01's avatar
      Imam01
      New Member
      2 years ago

      Greg_Deckler [Index] does not exist in my table. And when filling [vehicle License Plate] with the correct column names it does not recognise the names of the columns. For reference the column names in the table have been renamed for user clarity

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Imam01 The second formual assumes that the "Index" is a measure. You need to use the actual column names and measure names in the formula. Since I don't have a sample of your data (hint) all I can go by are the names of the things you share in your screen shots. So, if you need things to be more specific, please share additional details because I am not omniscient and can't possibly know what you have named or renamed.