Forum Discussion
How to Calculate Cumulative Percentage
Community ChampionImam01 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
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
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.