cancel
Showing results for
Did you mean:  Helper I

Cumulative measure sort by the biggest percentage

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 ?

1 ACCEPTED SOLUTION  Community Support

Hi @malekzouaridk,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.  Community Support

Hi @malekzouaridk,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.  