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.

Announcements