Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |