Cumulative measure sort by the biggest percentage

[Anonymous]

Hello Community,

I created a table in power bi desktop with two columns Product and percentage of distinct count of Number of ligns which I sorted to display values from big to small, I want to create a new column which display the cumulative percentage of number of ligns . For example here I want the first row display 5.52%, the second one 10.11% the third one  14.12%...

Is there a way to do it through calculated column or a measure ?

Thanks in advance

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Please create an index column to your table to sort your records, then you can write measure expressions with a variable table to calculate the percent of the current product. Then you can use the iterator function to apply the second aggregate on the variable table results.

Measure =
VAR currIndex =
    MAX ( Table[Index] )
VAR summary =
    SUMMARIZE ( 'Table', [Index], [Product], "Percent", [%TG] )
RETURN
    SUMX ( FILTER ( summary, [Index] <= currIndex ), [Percent] )

Regards,

Xiaoxin Sheng